Thread: Inserting same character into multiple cells--Macro?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
  
Posts: 2,819
Default Inserting same character into multiple cells--Macro?
in B1 put ="0"&A1

Copy down 222 rows. then Select and Copy Paste Special, Values over the
223 rows in Column A

marti wrote:

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?

Reply With QuoteReply With Quote