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
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
You also can't use a Colon to denote a ratio within a cell, IE 2:3
will be converted to the TIME 2:03When Excel sees a Slash it's a DATE
when it sees a Colon it's a TIMEIt's the little things that get'ya
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.
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::
