one way:
Dollars = int(T3)
cents = T3 - Dollars
HTH
Alan P.
"alison via OfficeKB.com" wrote in message
...
I have a spread sheet that has a dollar/cents amount (ie 23.47) and I'd
like to separate it into two different cells ( ie 23 in one cell labeled
dollars and 47 in another ). This is for a mail merge where the word
documents states 23 dollars and 47 cents.
I'm able to get a result using =LEFT on the dollars and =MID with the
cents
BUT if the amount is 123.00 I get errors on both dollars and cents
the actual functions are
=LEFT(T3,FIND(".",T3)-1)
=MID(T3,FIND(".",T3,1)+1,LEN(T3))
thanks for all and any help
--
Message posted via http://www.officekb.com