Number format

[Guest]

I'm having trouble formatting a number to a number. e.g...... from 16250 to
16,250.00. When I go into format and try to change it, it does not do it?
Do I need to do something else? I've tried everything to change the number
since I have to type in a formula and it just doesn't do it.

 

[Alex]

You should set the cell format to 'Number' and ensure
that the decimal places counter is set to '2'. This ought
to change 16250 to 16250.00

Alex

 

[Gord Dibben]

Rena

Format>Cells>Number>Number. Check the box at "Use 1000 Separator"

Also set the decimals to "2" using the spinner.

Note: you can add this to Format>Styles>Normal and "Modify"

Gord Dibben Excel MVP