How to display leading zeroes e.g. 000123 as data entry in Excel?

G

Guest

I am entering employee numbers in to Excel and of course, the leading zeroes
are removed. How do I avoid this?
 
J

JulieD

Hi Tony

you've got a couple of options
1) if you're not going to use the numbers in calculations you can format the
cells to text (format / cells / text) BEFORE entering the numbers
2) or type an apostraphe in first (') before the number (e.g. '000123)

3) if you need to use these as "numbers" later on, then make a custom cell
format,
select the cells, choose format / cells / click on custom and type 000000 in
the white line on the right
click OK

Cheers
JulieD
 

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

Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
Format cells in web query (leading zeroes) 5
Download/Import from Tab Delimited - Formatting of Data 5
Probably a Stupid Question 10
Leading Zero Dropped in Text Cell 3
CSV leading zeroes 2
Inputting variable length data - outputting fixed character result 2
Leading zeroes get dropped when converted to text 8

Top