Forum Discussion

David Denkenberger

Copper Contributor

Nov 13, 2018

Many numbers go to date format

How can I switch the default number format to general?

excel

Haytham Amairah

Silver Contributor

Nov 13, 2018

Hi David,

The General format is the default number format, to reset your numbers to this format, just select them, then press Ctrl+Shift+~ .

For more info, Please check out this https://support.office.com/en-us/article/reset-a-number-to-the-general-format-f71c3094-4231-408b-aef9-2f9506fa3021.

Regards

David Denkenberger

Copper Contributor

Nov 13, 2018

Thanks for your quick response! However, I don't want to have to change the format afterward. For some reason the default got changed to date, so when I type a number in like 41, it goes to a date.