Solved Excel is automatically entering dates

December 14, 2012 at 11:24:36
Specs: Windows 7

Excel 2010 is automatically entering dates.
Take for example I type in 1/28 for 1 out of 28 it gets replaced with Jan-28 in date format. I am really confused. Can anyone help me with this as It is an URGENT matter

See More: Excel is automatically entering dates

Report •


✔ Best Answer
December 14, 2012 at 18:37:38

Another option is to pre-format all of the cells that you are planning to enter this sort of data into as text. As long as you are not going to do any calculations on the data, this will prevent it from automatically switching to date formatting.

-----
IT Desktop & Network Consultant - MOS Master Certified, MCP, MCSA, MCITP - Windows 7, CCNA Certificate Pending, A+, Network +

::geek::



#1
December 14, 2012 at 11:35:50

What are you trying to get? if you just want to see "1/28" then put a single quote in front of it i.e.

'1/28

if you want to calculate 1 divided by 28 put an = sign in front


Report •

#2
December 14, 2012 at 12:19:49

You also can't use a Colon to denote a ratio within a cell, IE 2:3
will be converted to the TIME 2:03

When Excel sees a Slash it's a DATE
when it sees a Colon it's a TIME

It's the little things that get'ya

MIKE

http://www.skeptic.com/


Report •

#3
December 14, 2012 at 16:42:38

Those are just a couple of Excel's ways of "thinking ahead" and trying to help you.

Sometimes it a good thing, sometimes not.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
December 14, 2012 at 18:37:38
✔ Best Answer

Another option is to pre-format all of the cells that you are planning to enter this sort of data into as text. As long as you are not going to do any calculations on the data, this will prevent it from automatically switching to date formatting.

-----
IT Desktop & Network Consultant - MOS Master Certified, MCP, MCSA, MCITP - Windows 7, CCNA Certificate Pending, A+, Network +

::geek::


Report •


Ask Question