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.

 

Sfrlekin

1 Reply

@sfrlekin 

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.

S1393.png