Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Entry error In Microsoft Excel 2000
Hi ,
When I am trying to enter a date previous to the current date and any future date in an excel template which is having macros running.For eg If i give a current date the template will work and will go into the worksheet.But when I tried to give any previous date or any future date it is giving a "DATE ENTRY ERROR" and the template is not working at all. I tried to check the short date in the control panel and made the date settings as dd/mm/yy format and tried for the template.Still it is allowing only for the entry for the present date.No user can enter any previous date and any future on the template.xls. Please suggest the solutions as early as possible.This is very URGENT for me Thanks and Regards |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Entry error In Microsoft Excel 2000
I could be way off base here, but it sounds to me like Data Validation. Try
looking at Data Validation, and see if anything there strikes you as unusual or unnecessary. Here is some documentation for DV: http://www.contextures.com/xlDataVal01.html#DataVal01 Regards, Ryan-- -- RyGuy "Binu Gopal" wrote: Hi , When I am trying to enter a date previous to the current date and any future date in an excel template which is having macros running.For eg If i give a current date the template will work and will go into the worksheet.But when I tried to give any previous date or any future date it is giving a "DATE ENTRY ERROR" and the template is not working at all. I tried to check the short date in the control panel and made the date settings as dd/mm/yy format and tried for the template.Still it is allowing only for the entry for the present date.No user can enter any previous date and any future on the template.xls. Please suggest the solutions as early as possible.This is very URGENT for me Thanks and Regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
exel error 1706 microsoft office 2000 sr-1 professional | Excel Discussion (Misc queries) | |||
microsoft excel help dealing with data entry forms....please help | Excel Worksheet Functions | |||
Microsoft Excel 2000 | Excel Discussion (Misc queries) | |||
Change individual cell heights/widths in Microsoft Excel 2000 like Microsoft Word | Excel Discussion (Misc queries) | |||
Microsoft excel 2000 | Excel Worksheet Functions |