formating numbers

[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

 

[Fredrik Wahlgren]

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

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

 

[Niek Otten]

Format>Cells>Number, Decimal places = 2

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel