Forum Discussion
daleflinn
Oct 26, 2024Copper Contributor
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...
Harun24HR
Oct 26, 2024Bronze Contributor
Format the cells as TEXT instead of General. Another way to add single quote in-front of text like '6-9240.