Forum Discussion
Unwanted automatic change of text number format to scientific
I have a simple spreadsheet in which I was trying to list "codes" for keeping track of data for a game I'm working on. (Table top dice game) I find that the codes 01P2 or 01G2 can be found and repla...
Hi John,
You have an option to preset the Text format on empty cells before you enter the code.
Select the targeted cells, and press Ctrl+1 to open the Format Cells dialog box.
After that, just select the Text category, and then hit OK.
By the way, there is an https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10374741-stop-excel-from-changing-large-numbers-actually in the Excel's suggestion box asking for something similar.
Regards
Haytham