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

  • Thread starter Thread starter Sat
  • Start date Start date
S

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
 
Hi Sat!

Put 1000 in an empty cell
Select that cell
Copy
Select the cells to be converted
Edit > Paste Special > Multiply > OK
 
or if the entry is in cell a11 - this assumes entries like 5k, 5.1k
5.111k

=LEFT(A11,LEN(A11)-1)*100
 
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
Click to expand...

Strip off the k and multiply by 1000.

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





--ron
 
Back
Top