I need to add a decimal point to a column of numbers. For example, where it says 126 needs to be changed to 1.26, 3035 changed to 30.35, 13593 to 135.93 and so on. Can this be done automatically or with a formula?
Thanks!
I need to add a decimal point to a column of numbers. For example, where it says 126 needs to be changed to 1.26, 3035 changed to 30.35, 13593 to 135.93 and so on. Can this be done automatically or with a formula?
Thanks!
Last edited by KarambaStar; 01-17-2009 at 04:39 PM.
Place 100 in a blank cell > copy the cell > now select the numbers > right click > paste special > divide
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
You...are...super...awesome. Worked great! Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks