A simple custom format of 00000000 will not do the job?

If not, in a helper column enter =0 & cellref

Copy down.

But why do you need the dates as 02042009 ?


Gord Dibben MS Excel MVP

On Mon, 31 Aug 2009 12:53:01 -0700, 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?