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?
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

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?
 

Forum statistics

Threads
1,141,224
Messages
5,705,116
Members
421,378
Latest member
CarlosDuran

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top