10/22 keeps changing to 22-Oct


Joined
Mar 31, 2015
Messages
1
Reaction score
0
I want to put 10/22 which is a gun, but it keeps changing it to 22-Oct, I have changed the format to number but it keeps changing it to the date. How do I get it to keep the 10/22 that I want?
 
Ad

Advertisements

Joined
Feb 2, 2016
Messages
25
Reaction score
9
If you want to write 10/22 as text then put an apostrophe before it to tell Excel to keep it text. So, type '10/22 in the cell.
 
Ad

Advertisements


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


Top