ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Zeros being deleted, Example 1200 to 12, why is this? (https://www.excelbanter.com/excel-discussion-misc-queries/149494-zeros-being-deleted-example-1200-12-why.html)

Link34521

Zeros being deleted, Example 1200 to 12, why is this?
 
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.

Peo Sjoblom

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.





All times are GMT +1. The time now is 07:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com