View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
EllenM EllenM is offline
external usenet poster
 
Posts: 78
Default Reformat numbers

Thanks to everyone who answered my question. All your quick responses worked!!

"Bernard Liengme" wrote:

I use Custom Format #-##-# to get
123456789 to 123456-78-9
12345 to 12-34-5

But I do not understand you reference to leading zeros perhaps you already
have custom format to get them
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"EllenM" wrote in message
...
Hello,
I have a bunch of 9 digit numbers in a column that I'd like reformatted.
I'd like to remove the leading zeros and put the remaining numbers in
xxxxxx-xx-x format. For instance:
123456789 becomes 123456-78-9
000012345 becomes 12-34-5

Thanks in advance,
Ellen