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: 9
Default date problem

this is probably some rookie mistake that i am just not thinking of.
i enter the date 2.19.1979 but it shows as 28905 & i can't make it
show the other way. i have 3 worksheets in the workbook & only 1
shows the dates this way. i tried the obvious format cells option but
it didn't change.

its monday & my brain is not working right, your help is appreciated.
thanks, e
 
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
Exel increment date problem wrt todays date. [email protected] Excel Worksheet Functions 1 November 11th 07 06:58 PM
Date Formula Problem - Leave date blank if Null Gayla Excel Worksheet Functions 5 April 24th 07 09:42 PM
Date problem ehale Excel Worksheet Functions 3 November 28th 06 05:24 PM
Date Problem !! cassy01 Excel Discussion (Misc queries) 1 October 4th 05 11:17 PM
Date Problem Subs New Users to Excel 1 September 27th 05 01:35 AM


All times are GMT +1. The time now is 07:40 PM.

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"