Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 10th 04, 09:08 AM
DOMINIC JOSLIN
 
Posts: n/a
Default Entering date QUICKLY

Do you know how to enter dates (in non US format) without using the /
character? Eg 091204 instead of 09/12/04. I have seen it done, but don't
know how.



  #2   Report Post  
Old December 10th 04, 09:21 AM
Niek Otten
 
Posts: n/a
Default

Please post to one group only.

See my answer in other group

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"DOMINIC JOSLIN" wrote in message
...
Do you know how to enter dates (in non US format) without using the /
character? Eg 091204 instead of 09/12/04. I have seen it done, but don't
know how.



  #3   Report Post  
Old December 10th 04, 09:47 AM
Frank Kabel
 
Posts: n/a
Default

Hi
use the following addin:
http://www.xldynamic.com/source/xld.QDEDownload.html

--
Regards
Frank Kabel
Frankfurt, Germany

"DOMINIC JOSLIN" schrieb im Newsbeitrag
...
Do you know how to enter dates (in non US format) without using the /
character? Eg 091204 instead of 09/12/04. I have seen it done, but

don't
know how.





Reply
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
Date updates from worksheet to chart & changes date to a date series! Help!! Jayjg Charts and Charting in Excel 2 January 22nd 05 03:00 PM
Date issue between Windows and Macintosh version dlg1967 Excel Discussion (Misc queries) 4 January 19th 05 03:51 PM
In Excel 2003, entering date without slashes, the date is incorre. sj Excel Discussion (Misc queries) 6 January 6th 05 03:07 PM
Entering dates QUICKLY DOMINIC JOSLIN Excel Discussion (Misc queries) 4 December 10th 04 09:46 AM
Addition to Turn cell red if today is greater or equal to date in cell Rich New Users to Excel 2 December 9th 04 02:06 AM


All times are GMT +1. The time now is 09:46 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017