formating numbers

S

Sam

Hi,
For some reason when I type 6.00 in my cells, excel formats my cell as
6 and removes the zeros of the fractional part. How can I overcome this
problem ?

Thx
 
F

Fredrik Wahlgren

Sam said:
Hi,
For some reason when I type 6.00 in my cells, excel formats my cell as
6 and removes the zeros of the fractional part. How can I overcome this
problem ?

Thx
Click to expand...

Select the cell, column or row where you want two decimals. Select
Format|Cells and click on Numbers. Make sure you use 2 decimals. Click OK.

/Fredrik
 
N

Niek Otten

Format>Cells>Number, Decimal places = 2

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Top