"Add Mode" in Excel

A

Andrew

Hi all,
On many adding machines there is an “add mode†where you can enter numbers
without hitting the decimal point and the decimal point is automatically
added at two places. Is there an equivalent setting in Excel for data entry?

Thanks
Andrew
 
D

David Biddulph

Tools/ Options/ Edit/ Fixed decimal places
(but remember to turn it off again when you want normal entry).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top