View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Loyd Loyd is offline
external usenet poster
 
Posts: 1
Default Formatting Day() Function results

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.