Posted to microsoft.public.excel.programming

PhilM[_2_] PhilM[_2_] is offline

external usenet poster

Posts: 12

Excel date input inconsistancy

I have created a spreadsheet for data collection which is utilising
userforms for this purpose. The data is for the last financial year
(06-07) and the date options in the combo box reflect this (using
month only) When selected though the year changes to 07 from 06 (ie
April 06 as selected becomes April 07) How can I rectify this?

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
Excel 2002: How to overcome inconsistancy in auto cell function ?	Mr. Low	Excel Discussion (Misc queries)	7	August 2nd 07 04:28 PM
Can excel have a button to input (stamp) the systems date and/or .	abe	Excel Worksheet Functions	5	April 24th 07 10:00 PM
Excel date input inconsistancy	PhilM[_2_]	Excel Discussion (Misc queries)	1	April 16th 07 04:28 PM
Iteration inconsistancy	Ken G.	Excel Discussion (Misc queries)	0	March 15th 07 01:09 AM
excel input date format	NoelH	Excel Programming	1	January 11th 06 11:15 PM

All times are GMT +1. The time now is 06:05 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us