On Wednesday, February 1, 2017 at 4:58:23 PM UTC, Claus Busch wrote:
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

Thanks Claus, that works when I have a number but when the decimal is 00, it just populates as 0, and I don't know how to populate the second zero, any ideas?

I really appreciate your help on this!