Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default inserting a date in a form

I have an excel form in which I want to place a date in a textbox, what I
would like to type in is 260904 and the output to be 26/09/04
can any one help??

--
regards
ALEX


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default inserting a date in a form

Hi
see:
http://www.xldynamic.com/source/xld.QDEDownload.html

--
Regards
Frank Kabel
Frankfurt, Germany

"alex.simms" schrieb im Newsbeitrag
...
I have an excel form in which I want to place a date in a textbox,

what I
would like to type in is 260904 and the output to be 26/09/04
can any one help??

--
regards
ALEX



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default inserting a date in a form

Try the QDE addin at Ron de Bruin's site: http://www.rondebruin.nl/qde.htm

also Chip Pearson's site:
http://www.cpearson.com/excel/DateTimeEntry.htm

--
Regards,
Tom Ogilvy


"alex.simms" wrote in message
...
I have an excel form in which I want to place a date in a textbox, what I
would like to type in is 260904 and the output to be 26/09/04
can any one help??

--
regards
ALEX




  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default inserting a date in a form


great thanks for info cpearson's site was the answer to my prayers.
thank you


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
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
Inserting Interactive Excel Form into PowerPoint SK Excel Discussion (Misc queries) 0 September 8th 08 04:19 PM
Inserting text into a PDF form? Yankee Clipper Excel Discussion (Misc queries) 2 May 24th 08 01:59 AM
How do you convert an uncoded date (e.g., 20080304) to a date form tenorofchange Excel Worksheet Functions 5 April 20th 08 02:56 PM
DATE IN TEXT FORM - NEED TO CHANGE IT DATE FORM SSJ New Users to Excel 3 October 27th 06 08:34 PM
Need help with inserting hyperlink into worksheet from a form ryssa[_6_] Excel Programming 0 June 30th 04 06:15 AM


All times are GMT +1. The time now is 11:10 PM.

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"