Thread: entering dates results in subtraction of numbers
View Single Post
  #1   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
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
Reply With QuoteReply With Quote