Customizing the number format in MobiSheets allows you to present your data in a more meaningful and personalized way.
Here’s how to apply a custom number format in MobiSheets:
1. Open your file and select the cell or range of cells that you want to create a custom format for.
2. Right-click and select Format Cells in the contextual menu.
3. In the Format Cells box, click on Custom and type in the desired format in the dialog box.
4. Click OK. The format will be applied to the selected range.
5. Next time you choose Custom format tab, your custom format will be available in the bottom of the list.
By following these simple steps, you can easily personalize how your data is displayed in MobiSheets, making it more readable and tailored to your needs.
Limitations:
- Formula-based cells: If a cell contains a formula, you might not be able to apply custom number formatting in the same way as you would to static numbers.
- Complex customizations: While you can create custom formats, extremely complex formatting (like conditional formatting combined with custom number formatting) may not be fully supported.
- Localization issues: While you can create custom number formats, MobiSheets may not support number formatting in multiple languages or locales. For example, decimal and thousands separators might differ depending on your region, and custom formats might not handle these variations well.