To round normally use the ROUND function. To round to the nearest multiple use the MROUND function. Select a cell next to the data and type this formula ROUNDUP A21 A2 is the data cell you need to round up and drag the fill handle to the cells you need.
Close bracket and press enter.
Once it is rounded the formula would simply subtract 001 from the number to get a99 value. Round to Nearest 5 To round to the nearest 5 you can simply use the MROUND Function with multiple 5. Select a cell next to the data and type this formula ROUNDUP A21 A2 is the data cell you need to round up and drag the fill handle to the cells you need. First the value the number that needs to be rounded and second the number of decimals.