S
snickers22
I'm looking to convert a decimal number(3.75) to a non-decimal number(375)
using a formulas. as I have hundreds of these to do.
using a formulas. as I have hundreds of these to do.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
N Harkawat
=--SUBSTITUTE(A1,".","")
and copy the formula down
and copy the formula down
C
Chip Pearson
Why not something like
=A1*100
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
message
news:[email protected]...
=A1*100
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
message
news:[email protected]...
B
BOB
Try
In a blank cell enter 100. Copy this cell and then highlight the cells you
want to convert. Right click and click paste special select values and
multiply.
HTH
In a blank cell enter 100. Copy this cell and then highlight the cells you
want to convert. Right click and click paste special select values and
multiply.
HTH
K
Ken Wright
Are all your numbers 2 decimal places or are some greater. Assuming you
have a mix, put 100 in a cell, copy the cell, select all your values at once
and do Edit / Paste special / Multiply. Now format all the cells so that
you only see integers and then do Tools / Options / Calculation tab / Check
precision as displayed. Hit OK and then go back in and uncheck it. Note
though that you will lose any decimal data anywhere in that tab.
have a mix, put 100 in a cell, copy the cell, select all your values at once
and do Edit / Paste special / Multiply. Now format all the cells so that
you only see integers and then do Tools / Options / Calculation tab / Check
precision as displayed. Hit OK and then go back in and uncheck it. Note
though that you will lose any decimal data anywhere in that tab.