View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Lars-Åke Aspelin[_2_] Lars-Åke Aspelin[_2_] is offline
external usenet poster
 
Posts: 913
Default decimal number interpreted as a date

On Wed, 22 Jul 2009 12:37:11 +0400, "aa" wrote:

When entering a decimal number, SOMETIMES Excel interprets it as a date -
how shall I fix it?


The cell where you enter the number does probably have a date format.
To change this, right click on the cell (or cells), select "Format
Cells..." and then select another format, e.g. "General".

Hope this helps / Lars-Åke