Forum Discussion
cell format keeps changing
I have formatted a column of cells to Number - General, yet when I enter a number, 6-9240, Excel keeps automatically changing the format of the cell to Date. How can I get Excel to stop overriding my format?
1 Reply
- Format the cells as TEXT instead of General. Another way to add single quote in-front of text like '6-9240.
