LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3
Default Date suddenly changed

Hi all.

This one is driving me insane. I have a spreadsheet (MS Excel 2003) with a
range of dates in column A.

While I was working on another area of the spreadsheet, the date in the
cells in column A suddenly changed to 5-digit numericals.
No matter how I try, I can't get the numerical back to date.

Anybody out there have any ideas?


Bjoern



 
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
all the general formats of the workbook suddenly changed to date. Miri Excel Discussion (Misc queries) 2 May 25th 08 12:23 PM
all the general formats suddenly replaced with date format. Miri Excel Discussion (Misc queries) 1 May 20th 08 12:47 PM
sheet background color suddenly changed to light green from normal Dan Excel Discussion (Misc queries) 0 March 28th 07 03:22 PM
Cell format has suddenly changed in all new spread sheets Andy Excel Discussion (Misc queries) 5 October 29th 06 08:16 AM
if a1 value changed then date in b1 DKY Excel Worksheet Functions 5 July 13th 05 09:31 PM


All times are GMT +1. The time now is 02:31 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"