Forum Discussion
Solved
Excel 2016
Hello, I am dealing a lot with decimal numbers, and find after every input I have to go back to format to get the decimal point to act.Is there a command I can use to keep the decimal point ...
Hi Michael,
You have an option to preset the format on empty cells before you enter the numbers.
Select the targeted columns, and press Ctrl+1 to open the Format Cells dialog box.
After that, just select the Number category, change the decimal places, and then hit OK.
Regards
Haytham
Hi Michael,
You have an option to preset the format on empty cells before you enter the numbers.
Select the targeted columns, and press Ctrl+1 to open the Format Cells dialog box.
After that, just select the Number category, change the decimal places, and then hit OK.
Regards
Haytham