Thread: Formatting cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
 
Posts: 896
Default Formatting cell

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