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

entering dates results in subtraction of numbers
 

don't use "=" sign

format your cells appropriately

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

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

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

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

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

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

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