May 04 2022 11:32 AM
In excel, at a former employer, I was capable of entering in excel dollar amounts without having to enter the decimal to indicate "cents" is enter 12599 and it would populate as 129.99. What settings do I need to activate to do this function.
Sfrlekin
May 04 2022 11:40 AM
Select File > Options.
Select Advanced in the navigation pane on the left.
Tick the check box "Automatically insert a decimal point" and make sure that Places is set to 2.
Click OK.