Sorry for the dumb question:

So in my dataset I put, for example, the number 1.30 down for a patient. I formatted all cells as numbers, and set the decimal places to 2. However, the number is displayed as 1.3.

I copied my data from a Word file, perhaps that has something to do with what is causing the problem? I can't think of anything else.

7

1 Answer

This way:

• Select the cells or column
• In the Home pane, click the arrow next to "Format" and select "Format Cells..."
• In the Number tab, click "Custom"
• Under "Type:" enter 0.00
• Click OK.

The result will look like:

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy