J jk51 Member Feb 24, 2017 #1 Hi, Help please. For example: cell is 52.37 - 60.51 and the format is general. I want to round up to 1d.p. like this 52.4 - 60.5 I got a list of 1000 rows of this column. How to do it using formula to do all round up to 1 d.p. in one go. Thank you. Mr Singh
Hi, Help please. For example: cell is 52.37 - 60.51 and the format is general. I want to round up to 1d.p. like this 52.4 - 60.5 I got a list of 1000 rows of this column. How to do it using formula to do all round up to 1 d.p. in one go. Thank you. Mr Singh
Hui Excel Ninja Staff member Feb 24, 2017 #2 In an adjacent cell say B1 =ROUNDUP(A1,1) Copy down If you just want the values, copy the new data and paste it as values ontop of the original data
In an adjacent cell say B1 =ROUNDUP(A1,1) Copy down If you just want the values, copy the new data and paste it as values ontop of the original data
J jk51 Member Feb 24, 2017 #3 Hi Hui, Thank you for your reply. 1 cell is 52.37 - 60.51 Output is 52.4 - 60.5 I still got an error using your formula '#VALUE'. Bw Mr Singh
Hi Hui, Thank you for your reply. 1 cell is 52.37 - 60.51 Output is 52.4 - 60.5 I still got an error using your formula '#VALUE'. Bw Mr Singh
Hui Excel Ninja Staff member Feb 24, 2017 #4 Goto the Name Manager add a New Name Test: =EVALUATE(Sheet1!$A$2:$A$1000) apply close Name Manager Goto B2: =Test Enter Copy B2 Down
Goto the Name Manager add a New Name Test: =EVALUATE(Sheet1!$A$2:$A$1000) apply close Name Manager Goto B2: =Test Enter Copy B2 Down
B bosco_yip Excel Ninja Feb 24, 2017 #5 Maybe, =ROUND(LEFT(A1,FIND(" ",A1)-1),1)&" - "&ROUND(MID(A1,FIND(" ",A1)+3,99),1) Regards
