View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Deepak G Deepak G is offline
external usenet poster
 
Posts: 7
Default 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