Converting $ to text, with decimal assumed

[mattmickle]

Hello all,
I'm looking for a formula to convert the following:

$1,234,567.89

to a text string that looks like the following:

123456789

It needs to en corporate the decimal, assuming the last 2 positions are cents.

I'm hoping this is fairly easy and I just haven't had enough coffee yet to figure it out.

Thanks in advance!

 

[steve the fish]

I dont know if that our dollar amount is a number or text but this should work either way:

=TEXT(SUBSTITUTE(A1,"$","")*10,"#")

 

[njimack]

=mid(substitute(substitute(a1,",",""),".",""),2,len(a1))

 

[mattmickle]

Steve,
That gets me close, but it's still rounding the last 2 digits.
that returned 12345679

 

[Finalfight40]

How about this:

=TEXT(SUBSTITUTE(RIGHT(A4, LEN(A4)-1), ".", ""), "0")

 

[mattmickle]

Neil,
That got me close, but lopped off the first number:
23456789

 

[mattmickle]

Final,
That's doing the same thing as Neil's. Chopping off the first digit. The original input is a dollar amount, if that makes a difference.

 

[njimack]

Final,
That's doing the same thing as Neil's. Chopping off the first digit. The original input is a dollar amount, if that makes a difference.

Does the cell contain a $ symbol per your OP?

 

[Finalfight40]

Ah ok i see how yours is formatted now, try:

=TEXT(SUBSTITUTE(A4, ".", ""), "0")

 

[mattmickle]

Got it! Thanks for your help!