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

Excel 2003

Format-Cells-Custom

insert dd


On 10 Lis, 14:01, 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

Just apply a custom format to the cell of:

m-dd

Then it will expect a proper date but will only display the month and
day part.

Hope this helps.

Pete

On Nov 10, 1:01*pm, 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

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

Hu,
right click on the mouse, cell format, custom, type

dd

"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