Right clickFormatCellsFrom 'Number' tab select 'Custom' and type

dd

OR to dispaly this as 1-10 for a date 11/10/2009
"1-"dd

and hit OK..Enter a date

If this post helps click Yes
---------------
Jacob Skaria


"WLMPilot" wrote:

I have 12 budgets in a worksheet. Currently, I indicate due date for an
expense as 1-31 (adjusted to match number of days in a month). Is there a
way I can type in the entire mm/dd/yy, and still display just the dd portion?

Thanks,
Les