How to change cell formats

I have a couple different Mitutoyo instruments and am using a data collector to enter measurements into my calc spreadsheet. I am having a very difficult time getting the correct numerical display.
When I measure a part and it measures 0.038954 then I push the data collection button and in the cell it reads 38954 I could really use the 0.0 to be displayed. I have right clicked the cell and tried messing with the different options but it always adds the . or 0 to the end of the digits, instead of the beginning. Anyone have any suggestions? Thank you in advance.

Please attach a sample file.

Spreadsheet 1. sample.ods (13.6 KB)

Just try Format Code with two commas at the end



Another question for you, if you don’t mind.
On the same chart that you helped me with earlier…
How can I get it set up so that if I give a minimum and maximum dimension for LibreOffice Calc spreadsheet, so that when I take measurements anything under/over will be designated with a color code?

I really hope that makes sense.

Thank you so much. It worked. Greatly appreciate it.