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