Unwanted rounding in a table

[KirinKalypso]

I have to do recipe cost sheets for culinary school. An important part of this is not rounding dollar values until the very last step of calculation, but every time I add anything past the 2nd decimal, with or without a dollar sign, it automatically rounds up/down without any input once I move the focus outside of the box. The number is not still there, it just gets obliterated. This is not a case of standard autocorrect, which doesn't activate when I navigate the cursor with the arrow keys, this happens no matter how I leave the box. I need it to stop automatically rounding, or at the very least only automatically round past the 4th decimal instead of the 2nd.
If it helps, the document had to be converted from a docx file.

[KirinKalypso]

Found a fix by turning off number recognition in the right click menu, but I don't see any reason for it to automatically be rounding my numbers down for any reason. I can't find any settings or anything related to this feature.

[FJCC]

The behavior I see is that, with number recognition on, numbers are displayed to two decimal places but the full value is still available. I entered 12.3456 in the top left cell and the cell displayed 12.35. In the cell to the right of that I entered an = sign followed by <A1> * 10000. The result was 123456. You can right click on a cell, or a selection of cells, select Number Format, and choose to display as many decimal places as you would like.

[keme]

Initial thoughts:

• The full number value should be retained for subsequent calculations, as per the comment from FJCC.
• The displayed value conforms to the default number format for table cells, so it is rounded to two decimals for display purposes.
• The table hailing from MS Word may have an impact, but I doubt it in this case.

If you need to display more than two decimals, you can alter the number format:

• Right click the cell where you want to alter formatting
• Click Number format in the context menu which pops up.
• Enter the appropriate format code for what you need.
  E.g. if you want leading zero before decimal point, and at least two decimals but more decimals if they are nonzero, you use the format code 0.00##########

If you are still having trouble after going through "the moves" as indicated, we may need to inspect the file to determine probable cause. Remember that this is a public place, so if you attach a file, make sure you remove or mangle any confidential content.