Try:

="'0" & A1 and this is not a typo. Its an apostrophe followed by a double
quote
--
Gary''s Student


"wliong" wrote:


Hi everyone,

I have a problem in my excel. I'm trying to add a digit "0" in front of
every number in one column. For example: if the number is 1234567, then
I want it to become 8 digit number, that is 01234567. So, in conclusion
I need one extra digit 0 in front of every number. Is there any way to
do that?

Thank you very much.


--
wliong
------------------------------------------------------------------------
wliong's Profile: http://www.excelforum.com/member.php...o&userid=28343
View this thread: http://www.excelforum.com/showthread...hreadid=488198