DD-MON-YYYY never D-MON-YYYY

[okey]

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

 

[Max]

Assuming data are real dates,
select the col, then click:
Format>Cells>Custom
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