Formatting cell

[WLMPilot]

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

 

[Jarek Kujawa]

Excel 2003

Format->Cells->Custom

insert dd

 

[Pete_UK]

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

 

[Jacob Skaria]

Right click>FormatCells>From '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

 

[Eduardo]

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

dd