View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Zeros being deleted, Example 1200 to 12, why is this?

Toolsoptionsedit and deselect fixed decimal places


--
Regards,

Peo Sjoblom



"Link34521" wrote in message
...
While trying to imput data into my worksheet the sheet is constantly
removing
my zeros. Such as the number 1200 turns into 12. This is only happening on
my
computer so I am wondering if maybe one of my settings may be off. Please
any
help would be very much appreciated.