Forum Discussion
excel, cell value in entire column reduce by 4 digits
Column of 12 digit values, reduce entire column by 4 digits, in this case eliminate the 4 zeroes from 12 digit so they become 8 digit numbers
Reduce 4 digit from where? Left, Right, Mid position? Do you have any sample data then desired output? If you want to reduce in same cell then have to use VBA macro. Otherwise LEFT(), RIGHT() or MID() function may give you expected result.