I have a number in Excel 475640.00 and I need it to be 4756.40. However the
entire column of numbers does not have the same amount of charcters. For
example in this column is also 61300 which should be 613.00 and 4567829.00
which should be 45678.29 I tried text fixed with but that didn't work
because of the different amount of charcters in each number. How can I
change this format so that all the numbers are correct?