date problem in excel 2003

[StanKorn]

HI,
I am trying to process on dates from a VFP 7 data file that we used to use to compare with the new SQL platform we are currently moving into. My problem is the date field from VFP is coming into Excel as a text field yyyymmdd and I can't seem to reformat it.
Can anyone help me with this?
thanks,
stan

PPRIORITY PDISC PDAYS PNET PURDATE TRANDTE DUEDATE DISDATE DISCOUNT PURAMT PAIDAMT
2 0.000 0 20 20030108 20030108 20030128 0 93.78 93.78
1 0.000 0 30 20030128 20030128 20030227 0 100.00 -





Remember - only dead fish go with the flow.

 

[TropicalFred]

You could use a formula like this (where E2 = Column E, Row 2):

=VALUE(LEFT(E2,4)&"/"&MID(E2,5,2)&"/"&RIGHT(E2,2))

This will return the MS date number which you can then format any way you like.

Good Luck.

 

[StanKorn]

Thanks, I'll try it tonight and let you know.
s


Remember - only dead fish go with the flow.