Is it possible to use the format codes to display numbers rounded to tens, hundreds, or thousands?
Say I have the number 11,234 and I want 11,200 to who in the cell, which format code would allow me to do that?
Notice that I know I can use ROUND() to round the number, but I want to keep them unrounded for further computations. Only visual display should be affected.
Suppose this is about the usage of a column:
Better don’t long for another lying format, but use a (probably later hidden) column for the actual values and another one for the rounded values and the respective display.
Could you tell me which custom format would display 12,345 as 12,000? There no such examples on the page you linked, and all permutations of commas and #s I tried fail
You may use simply #,"000". That is, you output your zeroes as text.
You may use simply #,"000". That is, you output your zeroes as text.
(-deleted-)
Ah, that works, thanks. I hadn’t though of using quotes. In fact #,",000" even keeps the thousand separating comma.