| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
entering dates results in subtraction of numbers
In one of the worksheets in my workbook, when I enter date as 31-3-2008
(dd-mm-yyyy) i get result as -1980 instead of 31 March 2008. This happens only in a particular sheet. How do I get it to display the date. -- Thanks n Regards Deepak G India |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
entering dates results in subtraction of numbers
don't use "=" sign
format your cells appropriately |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
entering dates results in subtraction of numbers
Thanks. However, this is not the problem. I am not entering the "=" sign. It
is automatically treating all cells where the text begins with a number as formula. -- Thanks n Regards Deepak G India "Jarek Kujawa" wrote: don't use "=" sign format your cells appropriately |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
entering dates results in subtraction of numbers
Tools/ Options/ Transition:
Unset whatever is set, particularly Transition formula entry. -- David Biddulph "Deepak G" wrote in message ... Thanks. However, this is not the problem. I am not entering the "=" sign. It is automatically treating all cells where the text begins with a number as formula. -- Thanks n Regards Deepak G India "Jarek Kujawa" wrote: don't use "=" sign format your cells appropriately |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
entering dates results in subtraction of numbers
Thanks, but doesn't solve the problem.
-- Thanks n Regards Deepak G India "David Biddulph" wrote: Tools/ Options/ Transition: Unset whatever is set, particularly Transition formula entry. -- David Biddulph "Deepak G" wrote in message ... Thanks. However, this is not the problem. I am not entering the "=" sign. It is automatically treating all cells where the text begins with a number as formula. -- Thanks n Regards Deepak G India "Jarek Kujawa" wrote: don't use "=" sign format your cells appropriately |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
entering dates results in subtraction of numbers
Make that change.
Then reenter your date to test. Deepak G wrote: Thanks, but doesn't solve the problem. -- Thanks n Regards Deepak G India "David Biddulph" wrote: Tools/ Options/ Transition: Unset whatever is set, particularly Transition formula entry. -- David Biddulph "Deepak G" wrote in message ... Thanks. However, this is not the problem. I am not entering the "=" sign. It is automatically treating all cells where the text begins with a number as formula. -- Thanks n Regards Deepak G India "Jarek Kujawa" wrote: don't use "=" sign format your cells appropriately -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel
|
|||
|
|||
|
entering dates results in subtraction of numbers
Thanks Dave, I have tried that. It does not solve the problem. If this was
the problem, then it would have occurred on all sheets of the workbook and not on only one sheet. Let me redefine the problem. When I enter any text which starts with a number like "3 blind mice", it assumes it to be a formula and gives an error message stating formula not correct. -- Thanks n Regards Deepak G India "Dave Peterson" wrote: Make that change. Then reenter your date to test. Deepak G wrote: Thanks, but doesn't solve the problem. -- Thanks n Regards Deepak G India "David Biddulph" wrote: Tools/ Options/ Transition: Unset whatever is set, particularly Transition formula entry. -- David Biddulph "Deepak G" wrote in message ... Thanks. However, this is not the problem. I am not entering the "=" sign. It is automatically treating all cells where the text begins with a number as formula. -- Thanks n Regards Deepak G India "Jarek Kujawa" wrote: don't use "=" sign format your cells appropriately -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel
|
|||
|
|||
|
entering dates results in subtraction of numbers
Try unchecking that
Tools|Options|Transition tab|transition formula entry I don't think you were successful in your previous attempts. Deepak G wrote: Thanks Dave, I have tried that. It does not solve the problem. If this was the problem, then it would have occurred on all sheets of the workbook and not on only one sheet. Let me redefine the problem. When I enter any text which starts with a number like "3 blind mice", it assumes it to be a formula and gives an error message stating formula not correct. -- Thanks n Regards Deepak G India "Dave Peterson" wrote: Make that change. Then reenter your date to test. Deepak G wrote: Thanks, but doesn't solve the problem. -- Thanks n Regards Deepak G India "David Biddulph" wrote: Tools/ Options/ Transition: Unset whatever is set, particularly Transition formula entry. -- David Biddulph "Deepak G" wrote in message ... Thanks. However, this is not the problem. I am not entering the "=" sign. It is automatically treating all cells where the text begins with a number as formula. -- Thanks n Regards Deepak G India "Jarek Kujawa" wrote: don't use "=" sign format your cells appropriately -- Dave Peterson -- Dave Peterson |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
entering dates results in subtraction of numbers
Thanks Dave & David. It works.
-- Thanks n Regards Deepak G India "David Biddulph" wrote: Tools/ Options/ Transition: Unset whatever is set, particularly Transition formula entry. -- David Biddulph "Deepak G" wrote in message ... Thanks. However, this is not the problem. I am not entering the "=" sign. It is automatically treating all cells where the text begins with a number as formula. -- Thanks n Regards Deepak G India "Jarek Kujawa" wrote: don't use "=" sign format your cells appropriately |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| entering dates | Excel Discussion (Misc queries) | |||
| Format option for decimal. e.g., entering 531 results in 5.31 | Excel Discussion (Misc queries) | |||
| Entering dates | Excel Discussion (Misc queries) | |||
| subtraction in a list of numbers that resets with a label. | Excel Worksheet Functions | |||
| subtraction with dates | Excel Worksheet Functions | |||
Linear Mode
