before import to access or save as text, convert date cell to text format by
using =Text(value,"mmm yyyy") formula


pls do rate

"kirkm" wrote:


Hello,

I have a spreadsheet where several columns are
custom formatted to mm ss and dd mmm yyyy.

When I try and link or inport this into Access - or
save as text, all the values change.

Changing the cell type within Excel also fails with
the date e.g becoming a 5 digit number.

Is there a method to convert these to text whille maintaining their
existing format?

Thanks - Kirk