| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Despite formatting a column in Excel 2002 worksheet as Short Date.
Having created a column formatted as a date in a 2002 Excel spreadsheet the
column a figure which seems to be the number of days from a date in 1900. It is recognised as a date in both the formula bar at the head of the spreadsheet and when the cursor is moved over the field. I have looked at all the options but cannot see anything that will change this. Can you please help Pete |
|
#2
|
|||
|
|||
|
It sounds like you toggled the formula view (nice for debugging worksheet
formulas). Tools|options|View tab|uncheck formulas. On my USA keyboard, I can toggle this setting with ctrl-` (control-backquote (the key to the left of the !/1 key)) Pete Whalley wrote: Having created a column formatted as a date in a 2002 Excel spreadsheet the column a figure which seems to be the number of days from a date in 1900. It is recognised as a date in both the formula bar at the head of the spreadsheet and when the cursor is moved over the field. I have looked at all the options but cannot see anything that will change this. Can you please help Pete -- Dave Peterson |
|
#3
|
|||
|
|||
|
Thanks for that - you hit the nail on the head!!!
I can now hand this over to my users with a clear conscience. Pete "Dave Peterson" wrote: It sounds like you toggled the formula view (nice for debugging worksheet formulas). Tools|options|View tab|uncheck formulas. On my USA keyboard, I can toggle this setting with ctrl-` (control-backquote (the key to the left of the !/1 key)) Pete Whalley wrote: Having created a column formatted as a date in a 2002 Excel spreadsheet the column a figure which seems to be the number of days from a date in 1900. It is recognised as a date in both the formula bar at the head of the spreadsheet and when the cursor is moved over the field. I have looked at all the options but cannot see anything that will change this. Can you please help Pete -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Column A is Town, Column B is names. How can Excel add & tell how. | Charts and Charting in Excel | |||
| Excel 2002 date formulas problem | Excel Worksheet Functions | |||
| Need to remove a password that noone placed on Excel worksheet. | Excel Worksheet Functions | |||
| Auto date changing in Excel is maddening | Charts and Charting in Excel | |||
| getting data from 2 excel sheets automatically | Excel Worksheet Functions | |||
Linear Mode
