View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PattiTechWriter
 
Posts: n/a
Default custom formatting??

Do you know if you can force a specific formatting for a column? What I want
to do is, I have a column with a MAC Address that looks like this:
005004a1b4a9 and I would really like to reformat it to something like this:
00-50-04-a1-b4-a9. Is there a way to do this automatically with the columns
already populated?

Thanks in advance!