Date Entry error In Microsoft Excel 2000

B

Binu Gopal

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
Date Formats 4
Publisher is filling blank lines with data 2
Date Format 10
Date Entry error In Microsoft Excel 2000 0
Forcing a date entry format of dd/mm/yyyy 1
Change date format in Excel footer 2
How to enter a date in DD-MM-YYYY format 2

Top