Turning to decimal in Excel

Navigation
1

I have a spreadsheet in which the width and height length are as follows: 0,07 (example)

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

How do I do this in all cells at once? Thanks

    
asked by anonymous 01.06.2016 / 18:05

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 height of the desired line.

Selection can be done 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 select all.

I used Excel 2013 to do the tests.

    
01.06.2016 / 19:26
SelectList with ViewBag Identify and archive old MySql records