Do not round when removing a decimal place

0

Downloaded a set of numbers for book folding. e.g. 

Page      Fold 1    Fold 2

  1           4.33      4.66

  2           5.0        5.98

  3           4.23      6.88

I wish to drop the last decimal place but not round up or down. These are just numbers there is no formulas in the cells. There are 498 pages, so to do this manually would be a chore.

Any help appreciated.

Thank You

Janine

Answer
Discuss

Answers

0

Insert a clumn with

type= round(cell,1)

Now insert one more column

Copy data from entire column where round off formula entered.

Now paste value in the new column.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login