How do I make 11.800 convert to 800 as a number not text

  • Thread starter Thread starter nave
  • Start date Start date
N

nave

I want to drop the 11. and have the cell next to it be 800. I want to
then be able to use that 800 and add other numbers to it. I am having
two problems, 1) the 11.800 always becomes 11.8 ( I have tried
increasing the decimals) and 2) if I have a different number like for
example 11.255 by using RIGHT I succeed in getting 255 but as text.
Please help.

Thank you all in advance
 
Hi Nave!

One way (of several):

=(A1-INT(A1))*1000



--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
ok thanks but I need a FORMULA for column B that will convert a serie
of numbers in A to the last three numbers but sometimes I only have
digits in A instead of 5. When anything .100, .200, .300 etc. comes u
in A excel makes it .1, .2, .3 I hope thats clear.

11.276 to 276

11.8?? to 800

11.119 to 119

The problem is when a number like 11.8 comes up
 
Hi Nave!

Please to have helped.

But Earl's =MOD(A1,1)*1000 would also work just as well.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Yes Norman,

Earl thank you as well. I made a mistake when I tried it

Thank you both for those quick response
 
Back
Top