Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date format with Excel 2007
I have a problem with Excel 2007, I have some cells with a date value
(11/06/2008), but when I save the file, close it and open it again, in cells I have this 39758. I formatted these cell to a date format, any date format, and when I save, close and open the file, I have 39758 once again. This only happens with a couple of files. Can you tell me what is wrong with this? How can I keep the date format in these cells? Thank you kindly in advance for your help. Ed Gonzalez |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date format with Excel 2007
Are the cells populated using a macro when the file is opened?
Apparently the values in the cells are being overwritten by new values with numeric/general format. Save a copy then in the copy Copy and PASTE SPECIAL|Values in place and see whether the problem reoccurs. "Israel" wrote: I have a problem with Excel 2007, I have some cells with a date value (11/06/2008), but when I save the file, close it and open it again, in cells I have this 39758. I formatted these cell to a date format, any date format, and when I save, close and open the file, I have 39758 once again. This only happens with a couple of files. Can you tell me what is wrong with this? How can I keep the date format in these cells? Thank you kindly in advance for your help. Ed Gonzalez |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date format with Excel 2007
Thank you for your quick response.
No, the file is not populated by a macro. I did what you suggested me, and not worked. I'm still having the same values. It's strange. "Sheeloo" wrote: Are the cells populated using a macro when the file is opened? Apparently the values in the cells are being overwritten by new values with numeric/general format. Save a copy then in the copy Copy and PASTE SPECIAL|Values in place and see whether the problem reoccurs. "Israel" wrote: I have a problem with Excel 2007, I have some cells with a date value (11/06/2008), but when I save the file, close it and open it again, in cells I have this 39758. I formatted these cell to a date format, any date format, and when I save, close and open the file, I have 39758 once again. This only happens with a couple of files. Can you tell me what is wrong with this? How can I keep the date format in these cells? Thank you kindly in advance for your help. Ed Gonzalez |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date format with Excel 2007
Can you send the file to me?
id to_sheeloo add @hotmail.com to the id Also change few of the cell values to something like Testing... in few cells enter a new date, highlight them etc. just to see whether they remain when you repopen or get overwritten.. "Israel" wrote: Thank you for your quick response. No, the file is not populated by a macro. I did what you suggested me, and not worked. I'm still having the same values. It's strange. "Sheeloo" wrote: Are the cells populated using a macro when the file is opened? Apparently the values in the cells are being overwritten by new values with numeric/general format. Save a copy then in the copy Copy and PASTE SPECIAL|Values in place and see whether the problem reoccurs. "Israel" wrote: I have a problem with Excel 2007, I have some cells with a date value (11/06/2008), but when I save the file, close it and open it again, in cells I have this 39758. I formatted these cell to a date format, any date format, and when I save, close and open the file, I have 39758 once again. This only happens with a couple of files. Can you tell me what is wrong with this? How can I keep the date format in these cells? Thank you kindly in advance for your help. Ed Gonzalez |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date format on axis in Excel 2007 | Charts and Charting in Excel | |||
File always opens with Date format set - Excel 2007 | Excel Discussion (Misc queries) | |||
How to convert text 'Jun-30-2007' to date format? | Excel Discussion (Misc queries) | |||
Excel 2007 Date Format Problem | Excel Discussion (Misc queries) | |||
Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) |