Converting a Date into a number without keeping Juilan date

[Krash878]

I have a task of converting Dates over to a number like the following

02/31/01 to 023101

However when I change it in excel it is saved as a custom date so when I try and convert it over to and AS400

02/31/01 to 36935

What I need to do is change the 02/31/03 to general text without it reverting back to Number of days since 1900

Thanks

Krash

 

[SkipVought]

Hi,

I assume that you will be exporting this data to the AS400 in mmddyy format.

You conversion is

=IF(LEN(MONTH(CellRef))=1,"0","")&MONTH(CellRef)&IF(LEN(DAY(CellRef))=1,"0","")&DAY(CellRef)&RIGHT(YEAR(CellRef),2)

Hope this helsp

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com