Date error

S

seetkh

Why is it that you key "4-25-2005" , then format to date, but it becomes an
error because it is negative date ?
 
J

Jerry W. Lewis

I cannot reproduce this.

What are your regional settings? Format as General, what is displayed
in the formula bar?

Jerry
 

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

Automatically Scheduled Task with Start on Constraint and Neg Slack 0
Countdown macro - display settings 2
VBA - exporting serial letters to single documents 0
Autofill Date in Word 15.33 for Mac 0
Timescalevalue update gives error 1101 0
Outlook 2010 can't find .pst file 1
Modify the gantt chart view in project center (WPA) (MS Project 2010) 0
Automation of scanned file storage based on content 0

Top