LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
lizzie
 
Posts: n/a
Default Weird dates appear in cells when I use Date format! Why?

when I change the formatting of a group of cells to a Date format and hit the
Enter key, some unknown random date appears in all the cells. Even when I go
into the cell and change the date, it doesn't change it to the correct date.
Why might this be happening?
 
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
Formating cells with date format Alexandre Duarte Excel Discussion (Misc queries) 3 December 15th 05 11:47 AM
Why Does Date Format Change on Chart John Taylor Excel Discussion (Misc queries) 0 September 11th 05 08:16 AM
Format Cells - Date options Ben Rum Excel Discussion (Misc queries) 1 May 25th 05 05:53 PM
How do I count cells in a column of dates between date ranges? Andrew82 Excel Worksheet Functions 2 April 14th 05 09:59 AM
Format cells as date bay Excel Discussion (Misc queries) 3 January 26th 05 05:34 PM


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