Apr 18 2020 06:36 AM
Can I default when entering numbers by defaulting to "numbers" rather than "general"
Apr 18 2020 07:31 AM
Hello,
The General Number Formatting remains the default which implies that you can have Number as the default
Apr 19 2020 01:20 AM
Sorry to be thick but I do not inderstand
It goes automatically to "General) then I have to click on "number"
What i am trying to do is have "number" come up as first choice instead of "General"
Hope thart makes sense
Apr 19 2020 04:00 AM
Apr 19 2020 04:24 AM
You have a few options.
1. Select your cells and apply number format "Number".
2. Go to the cell styles. Select cell style "Normal". Change the number format from "General" to "Number". Every cell in this workbook with cell style "Normal" will change to number format "Number".
3. Go to the cell styles. Duplicate an existing style and change the number format from "General" to "Number". Select your cells and apply the new cell style.