Stop .0 in [number].0 being cuf off, when [number] could have several decimal places?

[alba]

Numbers entered into a set of cells may have between 1 and 5 decimal places. If it is 1 decimal place and it is between .1 and .9 it enters fine (e.g.12712.9). But if I try and enter e.g.13712.0 into a cell it changes to 13712 automatically.

Any ideas how to stop it automatically cutting off the .0? Perhaps with a formula for forcing it to have between 1 and 5 decimal places..?

Help very much appreciated!

ETA
0 is also a possible value, if that makes any difference

[martindwilson]

format cell as number and pick as many places as you want

[alba]

thanks for the reply;

I'd like it to be automatically accepted because the final sheet will be a protected data entry form where the user doesn't do anything but type in the numbers

so ideally I'd like it to be 'programmed in'...

[brokenbiscuits]

If you format the whole column as indicated above, then it should be an acceptable solution as the users would not need to amend.

[alba]

Thanks for the suggestion; unfortunately there may be anywhere between 1 and 5 decimal places so although I could format it to 5 decimal places I'd prefer it if (e.g.) 13712.0 stayed like that as entered, rather than got changed to 13712.00000

[martindwilson]

try custom format #.####0

[DonkeyOte]

if 12712.10 should be listed as 12712.1 and 12712 as 12712.0 then you might try: #.0####

[alba]

Thanks both for those suggestions; #.0#### works perfectly!