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

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

You could create a new column and text them

=TEXT(A1,"dd mmm yyyy")

and

=TEXT(A1,"mm ss")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"kirkm" wrote in message
...

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