View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Corkey Corkey is offline
external usenet poster
 
Posts: 11
Default Cant get column to format

Hi all. Need your expertise as I am pulling my hair out. I am exporting
information into an excel sheet but it will not allow me to change the date
value that comes over so I can sort the information. I have tried formatting,
copying and paste special with values only, paste special with multiplying by
one from a cell that was formatted as number and nothing. I looked for any
conditional formatting and to no avail. I can not export the information any
other way than copying and pasting. I am using Excel 2003.

Any help would be truly appreciated. Thanks a bunch