leading zero's

Faye in Fort Worth

New Member
Joined
Sep 12, 2006
Messages
1
I have to use numbers, in my spreadsheets, that have leading zero's. Excel deletes these zeros each time I open the spreadsheet. I know how to use the cell format ->Cells -> custom catagory to return the zeros. What I want to do is to keep the zeros there without Excel deleting them. What process do I use?
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

patrickmuldoon99

Active Member
Joined
Jun 27, 2006
Messages
345
The only alternative I can offer is preceeding your number with an apostrophe (') which makes Excel handle the number as a string, thusly keeping preceeding zeros. To add the apostrophe, you can make a temporary column next door and use the formula (presuming number is in A1)

="'0" & A1

HTH
 

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
Hi, Faye in Fort Worth
Welcome to the Board !!!!

you can format them as text, before you enter the numbers
or you can put a quote before the numbers
'001234

kind regards,
Erik
 

grd

Board Regular
Joined
Oct 19, 2005
Messages
210
Not exactly sure what the problem is because if I use custom format of 00#,##0.00 for example or 0000.00 or whatever you need Excel keeps the format when I reopen it?
 

Watch MrExcel Video

Forum statistics

Threads
1,108,992
Messages
5,526,109
Members
409,685
Latest member
Bellybb

This Week's Hot Topics

Top