Solved my win/loss record 3-0 in excel it keeps changing to dates

December 12, 2013 at 12:15:24
Specs: Windows 7
How do I format the cell to input my win loss record (ex: 3-0) and not have it automatically change to the date (March 3rd)? I am in desperate need of help.

See More: my win/loss record 3-0 in excel it keeps changing to dates

Report •

✔ Best Answer
December 13, 2013 at 13:23:43
If all else fails, put an apostrophe before your first number:

'3-0

An apostrophe tells Excel that what follows should be considered to be text.

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



#1
December 12, 2013 at 12:33:39
Try to change the format for that cell to text.

Report •

#2
December 12, 2013 at 12:40:10
Thank you. I tried that already. I even tried to change it to general, but it still goes to date format. I don't know if there is a way that I can type in a custom format.

Report •

#3
December 12, 2013 at 19:24:16
The secret is to format the cell as text First, before you enter data.

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
December 13, 2013 at 11:06:40
otherwise, put an
="test"
into the cell, then change the cell content to e.g. 3-0.

Excel uses auto format for the cells and sometimes, Excel seems to be to smart for what the user wants.


Report •

#5
December 13, 2013 at 13:23:43
✔ Best Answer
If all else fails, put an apostrophe before your first number:

'3-0

An apostrophe tells Excel that what follows should be considered to be text.

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


Report •

Ask Question