tks mate...

i think should go with 3rd option.

"RyanR" wrote:

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 ---


"manovi" wrote:

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.

"RyanR" wrote:



"manovi" wrote:

Pls tell me how to change 23.40 in to 23400 in excel ?

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?