View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
LisaH LisaH is offline
external usenet poster
 
Posts: 6
Default why i cannot change a certain date format

i use jmp program and save file as .xls. when i open in excel, all data in
each cells shows up with apostrophes. I cannot remove the ' sign and cannot
change the date format
e.g 08/03/2007 01:30 AM to 2007/08/03 01:30.
I aslo encountered a box sig in between an empty space between characters.
How to remove them?
Anybody has any idea on how to solve these problems??