Thread: Formatting cell
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default Formatting cell

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