View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
marti marti is offline
external usenet poster
 
Posts: 15
Default Inserting same character into multiple cells--Macro?

I have an Excel 2003 worksheet that has 223 rows with dates listed as
2042009. I need this data to read 02042009.
Is there any way to do this without having to manually enter the zero in 223
times. Would a macro help?