I cannot find the way, how to create custom cell format in Excel.
For example, I have value 3.5555, which is displayed as 3.6.
I would like to get displayed 35 555.
If I insert number 5 … I would like to see 50 000. If I enter number 5.1 …. I would like to see 51 000.
I would like to basically display the values in 10 000.
Any ideas? Thanks!
Best Answer
Create a custom number format
On the Home tab, in the Number group, click More Number Formats at the bottom of the Number Format list Format Number box.
In the Format Cells dialog box, under Category, click Custom.
In the Type list, select the built-in format that most resembles the one that you want to create. For example, 0.00.
The number format that you select appears in the Type box.
In the Type box, modify the number format codes to create the exact format that you want. For example, 000-000-0000.
Your changes will not alter the built-in format. Instead, your changes create a new custom number format.
When you have finished, click OK.
Apply a custom number format
Select the cell or range of cells that you want to format.
On the Home tab, in the Number group, click More Number Formats at the bottom of the Number Format list Format Number box.
In the Format Cells dialog box, under Category, click Custom.
At the bottom of the Type list, select the built-in format that you just created. For example, 000-000-0000.
The number format that you select appears in the Type box.
Click OK.
Create and apply a custom number format