View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lisa W Lisa W is offline
external usenet poster
 
Posts: 6
Default Custom Format or use function?

I inserted numbers into a column and now want to format this column so that
it changes the numbers to appear as: 196-24-0-00-00-001-00-0-01 (ie, the -
appear in the same spot in each number)
I thought I could do it as a custom format but can't make it work. Thanks
for any help. Lisa