How do I change a number from 700.00 to 70000 without having to re

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

Guest

I would like to be able to convert a list of numbers from the following
formats 900.00, 40.00, 1.00 etc... to the following format 90000, 4000, 100
etc... without having to re-type the numbers. I need to get rid of the
decimal point but keep the zeros that are after the decimal point. Is there
a function or format that can accomplish this???

Thanks a million for your help!!!
 
The only way to do this would be to change the actual data by multiplying by
100. To do that, you can type the number 100 in a cell, Edit/Copy that cell,
then select the numbers to be converted and Edit/Paste Special and select the
Multiply and Values options.
 
PS: You can't accomplish this by formatting alone. You must change the actual
data.
 

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

Conditional Formatting from a group 6
Convert number to text as displayed 3
how do I automatically insert a decimal point? 1
Change number from multiple decimals to 2 3
simple currency addition in cell without having to enter decimal 8
Changing to a usable format - number 1
Fill/Extend Series adding decimal points to some numbers 1
how do I format the number in a formular that contain text? 2

Back
Top