LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 47
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date format on axis in Excel 2007 JAJ0111 Charts and Charting in Excel 0 January 30th 08 03:39 PM
File always opens with Date format set - Excel 2007 ale Excel Discussion (Misc queries) 0 December 30th 07 02:55 PM
How to convert text 'Jun-30-2007' to date format? kenny Excel Discussion (Misc queries) 2 March 24th 07 04:47 PM
Excel 2007 Date Format Problem terry Excel Discussion (Misc queries) 0 November 25th 06 06:16 AM
Excel 2000 date format cannot be set to Australian date format Brian Jones Excel Discussion (Misc queries) 1 March 30th 05 06:03 AM


All times are GMT +1. The time now is 01:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"