FormatCellsNumberCustom

Custom Format of 00


Gord Dibben MS Excel MVP

On Sat, 19 Sep 2009 18:56:01 -0700, Loyd
wrote:

I am using the day() function to create an invoice number based on the date
of the invoice. My problem is that the results of the day() function for the
first 9 days of any month only generates a one digit number.

How can I format the results so that day(2009/1/4) results in a 2-digit
number, 04, instead of 4?

Appreciate any help.