decimal number interpreted as a date
 

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

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

decimal number interpreted as a date
 

Please give an example of such a number, and how Excel interprets it.
--
David Biddulph

"aa" wrote in message
...
When entering a decimal number, SOMETIMES Excel interprets it as a date -
how shall I fix it?

decimal number interpreted as a date
 

2.7 ----2 july
just to make sure Excel uses comma for the decimal separator 2,7 gives the
same result

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Please give an example of such a number, and how Excel interprets it.
--
David Biddulph

"aa" wrote in message
...
When entering a decimal number, SOMETIMES Excel interprets it as a
date -
how shall I fix it?

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

decimal number interpreted as a date
 

Might be worth looking at your Windows Regional Options (in Control Panel).
If you've got date formats specified there as d.m.y, it might be worth
seeing what happens if you change to d/m/y and try putting the number in
again after that.
--
David Biddulph

"aa" wrote in message
...
2.7 ----2 july
just to make sure Excel uses comma for the decimal separator 2,7 gives
the
same result

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Please give an example of such a number, and how Excel interprets it.
--
David Biddulph

"aa" wrote in message
...
When entering a decimal number, SOMETIMES Excel interprets it as a
date -
how shall I fix it?