Removing decimal point

T

Tonya B

Hi: Does anyone know how to remove the decimal point in a
number but keep the following zeros? For example: I have
a number 62.00 and 62.90. I need the outcome to be 6200
and 6290 in the cell. If anyone can help me that would be
great. Thank you
Tonya
 
T

Tonya B

Thank you, that worked. I have to do a little more
formatting after that but that saved a lot of time.
Tonya
 
G

Gord Dibben

Tonya

Enter 100 in a cell.

Copy that cell. Select your other cells and Paste Special>Multiple>OK>Esc.

Delete the cell with 100.

Gord Dibben Excel MVP
 

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

How to count the numbers in a Word document? 0
Excel does not accept text format! 0
You'll need a new app to open this about link 1
Using project as a resource tracker 0
Fraction to Decimal 2
Mail Merge - displaying a conditional number of decimals 5
Excel is too complicated for me 4
Decimal point in general format 1

Top