Entering 3.9 - Excel means that is Date how tu turn off it

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I'm entering in cell "3.9" and Excel automaticaly recognizes as date
"2007.03.09".. This is bad..

How TURN OFF this feature..
 
That sounds like a mixture of having the cell formatted to date before you
enter the number, and the date separator in Windows/ Regional Options being
set to full stop rather than a slant. Try chaging the cell format to
General before you put in the data, and/or change your Windows date
separator to a slant.
 
You must log in or register to reply here.

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

IF formula to accept or reject based on numbers entered. 5
Email Address 2
Date Formatting 4
conditional format cells by date 2
Date versus number format 6
Excel autoformatting dates 1
How do I keep my name from appearing in the comment box in excel 2
Saving collected data? 1

Back
Top