Thread: How to add one digit "0" in the front of a number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
wliong[_5_] wliong[_5_] is offline
external usenet poster
  
Posts: 1
Default How to add one digit "0" in the front of a number

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

Reply With QuoteReply With Quote