when i enter 1-1 it keeps going to the date I'd rather it not do that how do i stop it?
K Kristen Apr 18, 2009 #1 when i enter 1-1 it keeps going to the date I'd rather it not do that how do i stop it?
J Jacob Skaria Apr 18, 2009 #2 Enter this as '1-1 into a cell which will format that as text.. If this post helps click Yes
J Jacob Skaria Apr 18, 2009 #3 If you have similar information to be entered into an entire column; select the column..Right click..Format Cells..as Text before you start entering the data//
If you have similar information to be entered into an entire column; select the column..Right click..Format Cells..as Text before you start entering the data//
F FSt1 Apr 18, 2009 #4 hi perhaps you forgot to mention that you can preceed the input with an apostrophe and accomplich the same thing. regards FSt1
hi perhaps you forgot to mention that you can preceed the input with an apostrophe and accomplich the same thing. regards FSt1