NUMTEXT - Utilizing only the dollars or cents

[SHADOWS]

Is there a way to utilize numtext to only reflect the numbers before or after the decimal point? For example, if I type in $48.52, can an equation be executed that only will reflect 48? If so, is it possible to only reflect 52?

Thanks y'all

 

[Richard Schollar]

If the value is in A1 then

=INT(A1)

will return 48, and

=MOD(A1,1)

will return 0.52 (assumes you enter the value in A1 as a proper numeric value).

 

[SHADOWS]

Brilliant! Thank you so much!