Adding 0 as prefix for number when number is quoted

**VIJEXCEL** · 04-05-2011, 04:27 PM

hi,

I am facing a problem while putting 0 as prefix when the number is quoted in excel.

I am folowing the steps as follows.

a. Copied Zips to the excel column
b. applied formulae ="'"&A1&"'" to put the values quoted
c. When apply the above formulae the pefix '0' is removed and rest of the number only displayed

i. 01001 is the zip
ii. after applying the above formulae, it becomes like this 1001

How to not miss the leading zero even after applying the formulae and putting them in quote.

Thanks,
VIJ

**TMS** · 04-05-2011, 04:46 PM

Maybe:

=""""&TEXT(A1,"00000")&""""

Regards

**VIJEXCEL** · 04-05-2011, 05:15 PM

Thanks a ton. This solved my problem.

**TMS** · 04-05-2011, 05:38 PM

You're welcome.

If your problem is resolved, please mark the thread as SOLVED.

To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save