add decimal placement

C

Christine

Can someone tell me how to add a decimal placement to a list of numbers (i.e.)
519; 4209; 817 and format them to show as 5.19; 42.09; 8.17 ? I would guess
that this is a common format, as I've done similar formatting in Access.
 
A

Anne Troy

Hi, Christine. If you actually want to change the values, put 100 in any
cell. Copy it. Select your values and hit Edit-->Paste special, Divide, OK.
Then make sure your cells are formatted to show two decimals.
*******************
~Anne Troy

www.OfficeArticles.com
 
Top