Posted to microsoft.public.excel.programming

posheroff[_2_] posheroff[_2_] is offline

external usenet poster

Posts: 2

Formatting a date from an input box

I am using an input box to enter a date. I'd like the end user to only have
to enter a 2-digit year, but have the system convert it to a 4 digit year.
How would I do that?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
input a date or update it based on date in another cell	Doug P	New Users to Excel	1	July 18th 07 11:25 PM
Input Box Formatting	Doctorjones_md	Excel Programming	2	January 31st 07 11:38 PM
formatting input boxes	cereldine[_38_]	Excel Programming	3	June 16th 06 02:37 PM
Conditional formatting - different cell colour for each year following from user input date?	StargateFan[_3_]	Excel Programming	20	January 11th 06 07:11 AM
Input box to formatting????	Simon Lloyd[_412_]	Excel Programming	1	May 6th 04 01:27 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us