add decimal placement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top