View Single Post
  #3   Report Post  
Niek Otten
 
Posts: n/a
Default

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