Hi everyone,

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

Thank you very much

--
wlion
-----------------------------------------------------------------------
wliong's Profile: http://www.excelforum.com/member.php...fo&userid=2834
View this thread: http://www.excelforum.com/showthread.php?threadid=48819

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

Both method works.
Thanks again Gary.


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

There are a few ways to get what you want. Here are 3:

If there are always the same number of digits (like in an Account
Number with 8 digits):

FormatCellsNumber tab
Category: Custom
Type: 00000000
(1234567 would display as 01234567)

or

FormatCellsNumber tab
Category: TEXT
(Since the value would actually be TEXT, you'd have to enter 01234567)


Alternatively, you could use a formula in another cell:

B1: =TEXT(A1,"00000000")
If A1: 1234567 B1 would return the text string "01234567"
Do any of those help?

Ron


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