HOW TO CHANGE DECIMAL IN EXCEL

  • Thread starter Thread starter manovi
  • Start date Start date
manovi said:
Pls tell me how to change 23.40 in to 23400 in excel ?
Click to expand...

In what context are trying to do this?
23400 = 23.40 * 1000

Can you enlighten as to why you are trying to do this... e.g. what's the
project?
 
Ryanr,

I hav this as weight (23.4) and it is huge list & i did tried below
suggestion earlier,
but in that case i have to insert one more column ,change & after that delte
the other column.

i 'm trying get this in one shot.
 
I think you're trying to turn water into wine....

I see three options:

1. The quickest would be to simply increase the decimal placement, but
that'll leave the decimal point (which you can't remove) and deal with it.

2. An extra column as per method previously posted

3. Write a macro to perform the operation for you ie.
the basic format would be (sorry haven't written vb for a while, but you'll
get the idea)

var k
while not lastrow{
k = currentrow.cellvalue * 1000
currentrow.cellvalue = k
}

Such that the macro, loops through every cell, grabs the value, multiplies
by 1000 and replaces the cell value.

Just depends how often you need to do this operation, if it was going to be
regular, then i'd be thinking about writing the macro to do it.
 
tks mate...

i think should go with 3rd option.

RyanR said:
I think you're trying to turn water into wine....

I see three options:

1. The quickest would be to simply increase the decimal placement, but
that'll leave the decimal point (which you can't remove) and deal with it.

2. An extra column as per method previously posted

3. Write a macro to perform the operation for you ie.
the basic format would be (sorry haven't written vb for a while, but you'll
get the idea)

var k
while not lastrow{
k = currentrow.cellvalue * 1000
currentrow.cellvalue = k
}

Such that the macro, loops through every cell, grabs the value, multiplies
by 1000 and replaces the cell value.

Just depends how often you need to do this operation, if it was going to be
regular, then i'd be thinking about writing the macro to do it.

--
Cheers,
RyanR

--- pls click yes if I''ve helped you ---
Click to expand...
 
Try this simple procedure:

enter 1000 into a new, unused cell,
right click in the cell and choose "Copy",
select the cells you wish to change,
right click in that selection and choose "Paste Special",
click on <multiply>,
then <OK>

And you're done.

Clear the cell with the 1000 in it.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

tks mate...

i think should go with 3rd option.
 
Back
Top