Formatting cell

W

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
 
P

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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top