Main Page 
PC Review
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Setup
why won't excel recognise times
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Setup
why won't excel recognise times
 |
why won't excel recognise times |
|
|
Thread Tools | Rate Thread |
14-06-2006, 12:19 PM
|
#1 |
|
Guest
Posts: n/a
|
why won't excel recognise times
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. |
|
|
14-06-2006, 12:40 PM
|
#2 |
|
Guest
Posts: n/a
|
Re: why won't excel recognise times
Try using a colon instead of a dot and leave a space before the am:
11:30 am will change to 11:30 AM Kerry wrote: > > 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. -- Dave Peterson |
|
|
|
14-06-2006, 01:18 PM
|
#3 |
|
Guest
Posts: n/a
|
Re: why won't excel recognise times
"Dave Peterson" wrote: > 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 > > Kerry wrote: > > > > 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. > > -- > > Dave Peterson > |
|
|
|
|
| Thread Tools | |
| Rate This Thread | |
|
|
