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

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
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
 
Upvote 0
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
 
Upvote 0
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?
 
Upvote 0

Forum statistics

Threads
1,217,756
Messages
6,138,428
Members
450,136
Latest member
Tabako1960

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
Back
Top