Custom formatted cells

  • Thread starter Thread starter kirkm
  • Start date Start date
K

kirkm

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
 
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)
 
Back
Top