How do I keep consistent formats(changing from number to general)

[esj001]

Hello --I have attached my spreadsheet----sheet2 is a due list created from sheet 1-----the problem is that when grabs rows from sheet 1 and transfers to sheet 2 column D and some cells in column F are supposed to be Dates format not general format--how do i keep this from happening, they are in the correct format in sheet 1------thanks in advance

[col12345]

Hi

I have looked at your WB, but I can't read your macro's as I'm not using Excel so my apologies if this answer isn't quite to your liking.

You need to format the columns

Right click on the columns that are meant for dates choose format, choose date and choose how you would like the dates to appear.

This will change all the cells to date format including those that are yet to be populated with data.

Hope this helps

cheers

col

[pike]

Hi esj001
You could possibly use the text function to change the Format but it will be text
example ...

Please Login or Register  to view this content.

what are the two formats?