Forum Discussion
entering money amounts, without having to input the "."
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
1 Reply
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.
