MrExcel Publishing
Your One Stop for Excel Tips & Solutions

decimal placement

Posted by Greg Buckley on October 14, 1999 9:48 AM

I have a file that I imported from our risc 6000 and converted to excel.
This file has columns of prices but when converted to excel did not pick
up the decimal place from the original file. The decimal needs to be 2
places from the right. Is there a way to add this decimal, in every
cell, in the proper place, without clicking on each individual cell and
adding it?


Posted by Chris on October 14, 1999 12:17 PM


You can divide every entry by 100. You can do this either by creating a formula in an adjacent column, or by typing 100 in an empty cell, copying it, highlighting the prices to adjust, and choose Edit|Paste Special|Divide.