View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
aa aa is offline
external usenet poster
 
Posts: 3
Default decimal number interpreted as a date

this makes sense, thank you
"Lars-Åke Aspelin" wrote in message
...
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