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

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

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?

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?

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?

Try this simple procedu

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

"manovi" wrote in message
...
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?

Doh! I forgot about that simple method :D
--
Cheers,
RyanR

--- pls click yes if I''ve helped you ---


"RagDyeR" wrote:

Try this simple procedu

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

"manovi" wrote in message
...
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?