Cell formatting showing thousands!

[frejafridolin]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Cant figure this out, trying to format cells to show thousand (rounded). The number 12800 should be viewd as 13. The help suggested the format #. but that just delivered 12800. (dot).

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

Cant figure this out, trying to format cells to show thousand (rounded). The
number 12800 should be viewd as 13. The help suggested the format #. but that
just delivered 12800. (dot).

It should work if the full stop (dot) is your thousands separator.

If you use, say, a comma (the standard in the US), then the custom
format should be

#,

 

[CyberTaz]

Formatting only affects the rounding of decimal place display, not whole
numbers. IOW, if the cell is formatted for 2 decimal places of accuracy
125.777 would display as 125.78 & an entry of 125 would display as 125.00,
etc. Quite honestly, I'm not sure that you can regulate in that way even
with a Validation Rule.

The =ROUND() function can be used to display the rounded value but it
wouldn't regulate the number of digits displayed. Using your example &
assuming 12800 is entered in A1 you could have the this formula in another
cell: =ROUND(A1,-3) which would display a value of 13000 in that cell.

Perhaps someone else can offer other options.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[frejafridolin]

Thanks, made it work by change to another format, save the file and then change back to the custom format....

 

[CyberTaz]

I misread what you were trying -- the custom format went right past me :-}

The character to be used after the [#] is dependent on your system settings,
so if you aren't using the period as a thousands separator it will be taken
literally. If using the comma as a thousands separator the custom format
should be [#,] as opposed to [#.] (without the brackets, of course).

Regards |:>)
Bob Jones
[MVP] Office:Mac