Fixed Decimal

By default when entering numbers with decimal places you must explicitely add the decimal place yourself when entering the number.
However if you are going to type in a large quantity of numbers which all have decimal places it is possible to let Excel add the decimal place for you automatically.


(Tools > Options)(Edit tab, "Fixed decimal").




Type the following numbers and press Enter.




© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext