@Dear All,
While downloading data, I received date with contains more than two decimals. Sample file attached. Here the rounding can be done with Round() function and copy + paste value. However, no of columns are larger and once separate column is inserted the whole formula gets affected. My query is how to use the Round(A1,0) function within the cell itself where is cell No and 0 is number no of decimals. Pressing Control + 1 and Custom format will do the same. but in the backend there is no change in decimal points. Sheet 3 is the main data where multiple colmumns with values.
Help is requested.
VDS
While downloading data, I received date with contains more than two decimals. Sample file attached. Here the rounding can be done with Round() function and copy + paste value. However, no of columns are larger and once separate column is inserted the whole formula gets affected. My query is how to use the Round(A1,0) function within the cell itself where is cell No and 0 is number no of decimals. Pressing Control + 1 and Custom format will do the same. but in the backend there is no change in decimal points. Sheet 3 is the main data where multiple colmumns with values.
Help is requested.
VDS