title: How to add a decimal in excel (2016) to the left for a whole column and also add the whole column up 112 = 1.12
body: <p>I have a spread sheet I'm trying to add up all the numbers and add a decimal point to the left for rows e2-e467 (example 112 = 1.12) I just copied and paste the 466 numbers and don't want to go through them one by one to add the decimal in it. I was able to add the column up but wasn't able to add he decimal to the left of all numbers. I found you can add a decimal to the right but not to the left.</p>