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

  • Thread starter Thread starter michelle
  • Start date Start date
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?
 
You have to make it a text... try adding a singel apostraphe before it... like

='0123
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Starting with a zero? 3
Import TXT file into Excel and keep first "0" on numbers 2
front end zero 1
Number format 4
Displaying the zero value in a cell 3
how to show numbers that begin with 0 in excel 2
Sort "text" numbers with and without leading zeros as numbers 1
Display zero at the begnning of a number sequence in Excel 2

Back
Top