200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
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
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.
