I need to display numbers in thousands and to two decimal places. So for example 6,789,782 as 6,789.78
I have used the custom number formatting 0.00, which returns 6789.78. If I then format the cell as a number to add back the comma thousand separator, the whole number comes back...
I have data which needs to be formatted with a thousand separator as below.
how can I do this without it displaying as below
I do not want it reflected in the case of hundreds.
I would like to set the format of a cell to the Japanese currency format. This means that the comma separator occurs at 4-digit interval instead of 3 (ten-thousand separator instead of thousand separator) like this:
1,000 -> 1000
10,000 -> 1,0000