| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Extract MS Excel Data embedded in MS Word | Excel Discussion (Misc queries) | |||
| How can i add times in Excel? | Excel Discussion (Misc queries) | |||
| Adding/Averaging Times in Excel | Excel Discussion (Misc queries) | |||
| How do I duplicate a sheet 20 times in an excel spreadsheet | Excel Worksheet Functions | |||
Linear Mode
