How can I stop excel from converting two numbers with a dash between into a day and a month?

Format this cell as TEXT





FORMAT menu -%26gt; FORMAT CELLS -%26gt; NUMBER tab -%26gt; Select TEXT.How can I stop excel from converting two numbers with a dash between into a day and a month?
'2-3How can I stop excel from converting two numbers with a dash between into a day and a month?
Make sure the cursor is on the cell you want to change. Then click Format Cells and click on General or Text whatever your entry is. You may have to type your entry again after you changed the format.
Since the excel cells are programmed to show dash as date fromat


Use ' before ur numbers


or


right click %26gt; format cells %26gt; under number tab select text