ExcelBanter - Extracting dollars and cents

B1: =INT(A1)
C1: =(A1-B1)*100 (custom format 00)

"Pradhan" wrote:

I have a task which I would assume would be really simple, but I am going
thru hoops to get this done, and there MUST be a simpler way. What I want to
do is separate and extract the dollars and cents from one figure. For
example, $1000.07, I need to extract this (for forms) to 2 separate
numbers...1000 (the dollar side) and 07 (the cent side WITHOUT a decimal
point, and must show 07, not just 7)

The dollar side is easy...I just use the TRUNC command, but the cents side
is painful because Excel calculates out to x decimal points so I can't use
the RIGHT command. What I end up doing is taking the dollar amount,
subtracting the TRUNCATED amount, multiplying by 100, adding 100. (In the
above case, this would yield 107...but actually 106.9999986). So I then need
to ROUND this and at last, take the RIGHT 2 characters.

There has got to be a better way to go from 1000.07 to 07. Any help would be
kindly appreciated.

Pradhan