entering money amounts, without having to input the "."

Occasional Visitor

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.



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.