Custom formatted cells
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
|