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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula for decimal point 4
Adding up in old distance's... 1
Adding Hours Worked Correctly 3
Automatically chnage number format of a range of cells 2
Access stripping decimal places in query 1
Moving Decimal Point 2
pivot table loosing decimals (vba) 1
Add a decimal to each number on a list of whole numbers 2

Back
Top