Decimalize in Excel

Asked

Viewed 36 times

1

Guys, I have a spreadsheet where the length and height are like this: 0.07 (example)

I need it to look like this: 7 (example)

How do I do that in all the cells at once? Thank you

  • 2

    Your question doesn’t seem to be well formulated.. Your title doesn’t seem to match what you want.. Explain it better.

1 answer

1

Select the column(A,B,C,D...) in question, right click, column width and enter the desired size. Do the same by selecting the line(1,2,3.) in question, right click, line height and enter the desired line height.

The selection can be made in one or more columns by clicking and dragging with the mouse.

If you want to select all rows and columns in your workbook use the Control+t shortcut and you will select all.

I used excel 2013 to do the tests.

Browser other questions tagged

You are not signed in. Login or sign up in order to post.