Prev Previous Post   Next Post Next
  #1   Report Post  
donna
 
Posts: n/a
Default dates


Hey Leith - I left D7 blank and entered the formula in the other cells.
The only thing is that it comes up with a date code ie 38507. How can I
change this to show the date ie July 30, 2005. Thanks a lot for your
help!! :)

Donna
from BC


--
donna
------------------------------------------------------------------------
donna's Profile: http://www.excelforum.com/member.php...o&userid=23725
View this thread: http://www.excelforum.com/showthread...hreadid=374029

 
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
Stop Excel Rounding Dates leinad512 Excel Discussion (Misc queries) 1 April 20th 05 04:19 PM
Finding Dates in a date range Marcus Excel Discussion (Misc queries) 1 April 5th 05 01:51 AM
Plotting Dates GGoetz Excel Worksheet Functions 1 March 30th 05 10:08 AM
Formating Dates for production schedule dpl7579 Excel Discussion (Misc queries) 1 January 11th 05 08:43 PM
due dates Niki New Users to Excel 4 January 10th 05 04:11 PM


All times are GMT +1. The time now is 03:43 AM.

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

About Us

"It's about Microsoft Excel"