Extracting dollars and cents
 

This gets an Ugh! Of course. I think my brain was fried from too much time on
the PC. However, I chose TRUNC instead of INT because INT rounds down and
TRUNC doesn't roung at all, so in the case of negative dollars, (which
unfortunately happens too often in my life) INT(-6,75) would yield -7, while
TRUNC (-6.75) yields the desired -6.

Thanks ms teethless

"Teethless mama" wrote:

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