How to add '00' in front of a column in excel2003

Any operation can do, or how to program in macro

Thanks.
turbot_yuAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
Rory ArchibaldCommented:
In another column, you can use a formula like:
="00"&A1
and copy down. Then copy and paste special-Values onto the original column if you wish.
0

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
 
jimyXCommented:
Add a single quote (apostrophe) '
'00
0
 
Saqib Husain, SyedEngineerCommented:
You can also use this custom number format

"00"General;;"00"@
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
turbot_yuAuthor Commented:
May I know where to put '00 and "00"General;;"00"@

Thanks.
0
 
jppintoCommented:
Right click on the cells that you want to format and select Format Cells. Then go where you can see on the attached image.

jppinto
Capture.JPG
0
 
Saqib Husain, SyedEngineerCommented:

Select the data
press ctrl-1
Select Number tab
Enter the string int the "Type" window
0
 
dolbyhomeCommented:
you can type '00 (single quote zero zero) into the actual cell
The General;;"00"@ setting will be in options of the number format of the cell
0
 
jimyXCommented:
As an simple operation, just to insert ' at the beginning of the value in the intended cell.
0
 
turbot_yuAuthor Commented:
I tried it gives error as below.

MS office excel cannot use the number format you typed.

Try using one ..............
0
 
Saqib Husain, SyedEngineerCommented:
Copy the entire line including quotes
0
 
Robert SchuttSoftware EngineerCommented:
Is prefixing with 2 zeroes really what you want? I've put 2 examples (number and text) in an excel sheet, basically just started with "Record Macro" and then pressed Alt-F11 to edit the code.

The first one changes the format, the second one updates the text cells, prefixing with "00", you can run the macro's by pressing Alt-F8.

 Book1.xls

Hope this helps!
0
 
turbot_yuAuthor Commented:
0
 
Saqib Husain, SyedEngineerCommented:
Is there any chance that you are using a regional settings where the delimiter is different from the comma....etc?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.