decimal number interpreted as a date

  • Thread starter Thread starter aa
  • Start date Start date
A

aa

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

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
 
2.7 ---->2 july
just to make sure Excel uses comma for the decimal separator 2,7 gives the
same result
 
this makes sense, thank you
Lars-Åke Aspelin said:
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
Click to expand...
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to interpret string as a number in Excel 2007 ? 3
Access stripping decimal places in query 1
How do I stop Excel from 'interpreting' my data? 7
Excel date formats 2
Fixed Decimals in Excel 2007 4
Importing txt-file with "." (= dot) as decimal separator doesn't w 2
Excel 2002 date entry: Cannot get away from d-m-yy entry format 3
Automaticallychanging the number of decimal places displayed 5

Back
Top