DD-MON-YYYY never D-MON-YYYY
 

I need to format a date column to show leading zeros in the DD part.
How do I do this?

I want 07-JUL-2009
I do not want 7-JUL-2009

Thank you

DD-MON-YYYY never D-MON-YYYY
 

Assuming data are real dates,
select the col, then click:
FormatCellsCustom
Type: dd-mmm-yyyy
Click OK

aha? punch the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"okey" wrote:
I need to format a date column to show leading zeros in the DD part.
How do I do this?

I want 07-JUL-2009
I do not want 7-JUL-2009

Thank you