| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help With a Date
I am entering
12/31/06 Enter in a cell and the spreadsheet is inserting and ='s sign before the 12 and performing the calculation 12 divided by 31 divided by 6. The only way to get the date to display has been to enter an apostaphe before the 12. This only happens in this particular spreadsheet. I have looked through the Options but I don't see anything obvious - does anyone know how to fix this? Many Thanks, |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help With a Date
Have you tried to format that cell using various date formats?
"lk" wrote in message ... I am entering 12/31/06 Enter in a cell and the spreadsheet is inserting and ='s sign before the 12 and performing the calculation 12 divided by 31 divided by 6. The only way to get the date to display has been to enter an apostaphe before the 12. This only happens in this particular spreadsheet. I have looked through the Options but I don't see anything obvious - does anyone know how to fix this? Many Thanks, |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help With a Date
(tools<options<transition Clear any check boxes
"lk" wrote: I am entering 12/31/06 Enter in a cell and the spreadsheet is inserting and ='s sign before the 12 and performing the calculation 12 divided by 31 divided by 6. The only way to get the date to display has been to enter an apostaphe before the 12. This only happens in this particular spreadsheet. I have looked through the Options but I don't see anything obvious - does anyone know how to fix this? Many Thanks, |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help With a Date
Toolsoptionstransition, deselect transition formula entry, in fact you are
probably better off deselecting evaluation and navigation keys if they are selected as well -- Regards, Peo Sjoblom "lk" wrote in message ... I am entering 12/31/06 Enter in a cell and the spreadsheet is inserting and ='s sign before the 12 and performing the calculation 12 divided by 31 divided by 6. The only way to get the date to display has been to enter an apostaphe before the 12. This only happens in this particular spreadsheet. I have looked through the Options but I don't see anything obvious - does anyone know how to fix this? Many Thanks, |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help With a Date
ToolsOptionsTransition. You are in Lotus entry mode.
Uncheck the transition options checkboxes. Gord Dibben MS Excel MVP On Mon, 9 Apr 2007 11:36:02 -0700, lk wrote: I am entering 12/31/06 Enter in a cell and the spreadsheet is inserting and ='s sign before the 12 and performing the calculation 12 divided by 31 divided by 6. The only way to get the date to display has been to enter an apostaphe before the 12. This only happens in this particular spreadsheet. I have looked through the Options but I don't see anything obvious - does anyone know how to fix this? Many Thanks, |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help With a Date
I unchecked the Transition boxes and it works!
Thank to all of you! "Gord Dibben" wrote: ToolsOptionsTransition. You are in Lotus entry mode. Uncheck the transition options checkboxes. Gord Dibben MS Excel MVP On Mon, 9 Apr 2007 11:36:02 -0700, lk wrote: I am entering 12/31/06 Enter in a cell and the spreadsheet is inserting and ='s sign before the 12 and performing the calculation 12 divided by 31 divided by 6. The only way to get the date to display has been to enter an apostaphe before the 12. This only happens in this particular spreadsheet. I have looked through the Options but I don't see anything obvious - does anyone know how to fix this? Many Thanks, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
| Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
| Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
| Make date change in excel to current date when opening daily? | Excel Discussion (Misc queries) | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
Hybrid Mode
