LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Problems with dates in Excel 2007

That changes the format of the cell. But since the user is already seeing a
date in the formulabar, I don't think this will help.

muddan madhu wrote:

<<snipped
Use Ctrl + Shift + #

to convert the 5 digit number to date format.


--

Dave Peterson
 
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
Problems sorting in excel 2007 Skybble Excel Discussion (Misc queries) 1 December 13th 07 08:53 PM
Two problems with Excel 2007 Pygmalion Excel Discussion (Misc queries) 0 October 22nd 07 08:34 AM
Excel 2007 Problems [email protected] Excel Discussion (Misc queries) 1 March 5th 07 07:30 PM
Problems with my links to an excel 2007 file from a word 2007 file sc Links and Linking in Excel 0 February 21st 07 10:12 AM
Having problems calculating dates in Excel. Russell Bachmann Excel Worksheet Functions 1 March 9th 06 05:55 PM


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