Number format

R

Rena62

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.
 
A

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
 
G

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
 
Top