View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kirkm[_6_] kirkm[_6_] is offline
external usenet poster
 
Posts: 156
Default 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