Find Decimal
=RIGHT(A1,LEN(A1)-FIND(".",A1))
Value becomes Text
=A1-INT(A1)
Remains a value
or
=A1-TRUNC(A1)
Remains a value
or
=MOD(A1,1)
This is the simplest!
© Copyright
andrewsexceltips.net
All Rights Reserved.