Hi Julie,

Am Wed, 1 Feb 2017 08:50:38 -0800 (PST) schrieb JulieS:

Thank you for that, is there anyway the decimals can be populated without the decimal point so it literally becomes 58?

multiply by 100:
=MOD(B1,1)*100


Regards
Claus B.
--
Windows10
Office 2016