formating numbers
 

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

"Sam" wrote in message
oups.com...
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

FormatCellsNumber, Decimal places = 2

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Sam" wrote in message
oups.com...
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