Urgent Help -Converting cell from "K" value to Full Value

[Sat]

Hi,

I am trying to convert cells with currency value in
thousanth of dollar to full value. eg. I want to change
5.25k to 5250.

Whats the quickest way to do it.

Appreciate an urgent reply

Sat

 

[Norman Harker]

Hi Sat!

Put 1000 in an empty cell
Select that cell
Copy
Select the cells to be converted
Edit > Paste Special > Multiply > OK

 

[duane]

or if the entry is in cell a11 - this assumes entries like 5k, 5.1k
5.111k

=LEFT(A11,LEN(A11)-1)*100

 

[Ron Rosenfeld]

Hi,

I am trying to convert cells with currency value in
thousanth of dollar to full value. eg. I want to change
5.25k to 5250.

Whats the quickest way to do it.

Appreciate an urgent reply

Sat

Strip off the k and multiply by 1000.

=1000 * TRIM(SUBSTITUTE(UPPER(A1),"K",""))





--ron