why won't excel recognise times

K

Kerry

my 2003 stable book says that when I autofill with a time, such as 11.30am,
the am should change to AM confirming its recognising the data as a time. My
excel 2003 won't do this. Why? And what do I need to do to change it? Only
recently updated from office pro 97.
 
D

Dave Peterson

Try using a colon instead of a dot and leave a space before the am:

11:30 am
will change to
11:30 AM
 
K

Kerry

Dave Peterson said:
Try using a colon instead of a dot and leave a space before the am:

11:30 am
will change to
11:30 AM

Dave, Thanks very much...great site
Click to expand...
 

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

Can't save my Office documents (after computer rebuild and reauthorization) 0
Embed the same Excel multiple times 0
Keeping to ms office 97 pro 0
Word 2003 won't exit 8
Working on birthday "book" for my wife and having layout/editing trouble 0
Getting Radio Buttons to work, that are inserted via AutoText 0
Powerpoint Ink Reacts Different in Different places 0
Excel suddenly crippled by Just-In-Time Debugging 2

Top