Date formatting Problems

**dkoucky** · 11-22-2010, 04:51 PM

I am trying to change my dates so they will fit into another company's computer program. They require dates to be formatted as eight digit numbers (if something was scheduled for January 1st 2011 it would read 01012011). Unfortunately I have literally thousands of cells that are formatted as dates (1/1/2011), when I change the formatting it converts the numbers using the 1900 date system. Is it possible to change these without hard coding them or using the worlds longest =IF statement? Thanks for your help!

**NBVC** · 11-22-2010, 05:01 PM

You mean?

=TEXT(A1,"mmddyyyy")

**dkoucky** · 11-22-2010, 05:07 PM

Excellent the I just paste values, convert to number, and use custom formatting 00000000!

Thanks!

**NBVC** · 11-22-2010, 05:20 PM

I am confused then why not just custom format as: mmddyyyy

in the first place?

**dkoucky** · 11-22-2010, 05:34 PM

I am figuring lead time from our warehouse to theirs, so the dates are figured using a VLOOKUP of the amount of days between each warehouse. This is then added into the ship date meaning I have to use dates and not numbers. But when I send our schedule to them it is plugged into a system that only understands numbers formatted as 00000000 numbers. So if I just changed the formatting their system would reject my inputs. Or the numbers get completely thrown off and show how much time has passed since 1900.