On Wednesday, February 1, 2017 at 5:19:54 PM UTC, Claus Busch wrote:
Hi,

Am Wed, 1 Feb 2017 09:07:24 -0800 (PST) schrieb JulieS:

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?

format D1 with custom numberformat 00


Regards
Claus B.
--
Windows10
Office 2016

Claus - Thank you so much! It works, you star! I really appreciate this.