Custom format to show integer number as decimal with fix amount of decimal digits

I am not aware of any number format code that will scale a number by 10,000 (4 decimal places). You can use a "," (or whatever your thousands separator is) to scale a numbers by thousands (multiples of 3 decimal places). For example, 350 formatted as 0.000, will display as 0.350. 47.68 with the same number format code will display as 0.048.

That's the closest number format solution I can see. I do not see an exact solution using only number formatting. Of course, there are ways to use formulas to divide a number by 10,000 then format to show to the nearest 0.0001.

If it helps, here's the help file that describes all available number format codes (in my early days of learning spreadsheets, this was one of my most frequently referenced help pages): https://support.microsoft.com/en-us/...7-9c9354dd99f5

rafo0510,

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.