How to show "0" at the beginning of a number sequence?

M

michelle

For example, if I type 0123 in a cell, the "0" disappears and will only show
the 123. How to I disable that auto correction?
 
A

akphidelt

You have to make it a text... try adding a singel apostraphe before it... like

='0123
 
F

FSt1

hi
this is not an autocorrection. leading zeros on numbers are not necessary so
xl dumps them. but in the real world, some "numbers" do have leading zeros
and are usually some kind of id meaning that they are not really numbers ie
do math to, they are number use as letters. so if you don't plan to do
anything mathmatical to your number/words then pre-format as text or preceed
the input with an appostrophe(').
xl will view these entries as text and will stop droping the zeros.

Regards
FSt1
 
P

Peo Sjoblom

There is no autocorrection for leading zeros, if you always use 4 digits you
can use a custom format like

0000

if not precede the entry with an apostrophe or preformat as text


--


Regards,


Peo Sjoblom
 
Top