Formatting cell
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 |
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 |
Formatting cell
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 |
Formatting cell
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 |
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 |
All times are GMT +1. The time now is 09:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com