| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i change text format date to date (i.e., mm/yy to mm/dd/yyy | Excel Discussion (Misc queries) | |||
| Use date modified to change format & create filter to track change | Excel Worksheet Functions | |||
| Can I change a date with no format (20051111) to date format? | New Users to Excel | |||
| Change general format to US date format | Excel Discussion (Misc queries) | |||
| how do I format cells to change date and time to just date | Excel Discussion (Misc queries) | |||
Threaded Mode
