Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to convert the numerical to text (ie 1200 to One thousand two | Excel Discussion (Misc queries) | |||
Essbase: Text zeros to number zeros | Excel Discussion (Misc queries) | |||
If No is deleted in middle of sequence,Nos alter after deleted No | New Users to Excel | |||
How do I manually calculate this formula PV(P3/1200,Q3,-N3*M3/100 | Excel Worksheet Functions | |||
save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) |