Problems with entry of Dates
Posted by Elbech on August 16, 2001 1:37 PM
Hi, this is my 1st posting here, so sorry if I ask a recurring question.
I'm running Excel2000 on Windows98, and in my spreadsheet dates are formatted as dd-mmm-yyyy.
All date-fields are labelled and are used in and for VBA macros.
When I wish to alter a date before recalculating, say, 16-Aug-2001, or 16/8/2001, or 8/16/2001, or 16/8/01, or 8/16/01, or 16-08-2001, or 08-16-2001, or 16-08-01, or 08-16-01, I only get an error message reading an infinite number of ########.
My regional settings in Control Panel is dd-MMM-yy.
Could anyone help me out here, please?
Thanks in advance,