Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
dates on forms
I am using excel to fill in and print delivery receipts for merchandise.
On one of the forms instead on one block for the date, there are three seperate ones for "Month", "Day", and "Year" I am using the WORKDAY function as the merchandise usually is delivered the day after the form is printed. Is there a way I can get Excel to display ONLY the Month, Day, and Year each in it's own cell?? Changing the form is not an option as they are specified, and provided by the vendor through whom the merchandise is being billed. Any help will be greatly appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
dates on forms
Roy,
If the same full date is in each one, just format the cells custom. e.g. Format = "d" (single or double digit day number displayed) Format = "dd" (double digit day number displayed (with leading zero)) Format = "ddd" (abbreviated day displayed (Wed, Thu, etc.)) Format = "dddd" (full day displayed ("Wednesday, Thursday, etc.)) The same works for the month also. Year is "yy" or "yyyy" John "Roy Schultz" wrote in message ... I am using excel to fill in and print delivery receipts for merchandise. On one of the forms instead on one block for the date, there are three seperate ones for "Month", "Day", and "Year" I am using the WORKDAY function as the merchandise usually is delivered the day after the form is printed. Is there a way I can get Excel to display ONLY the Month, Day, and Year each in it's own cell?? Changing the form is not an option as they are specified, and provided by the vendor through whom the merchandise is being billed. Any help will be greatly appreciated. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
dates on forms
Don't understand why you have a problem. The simple answer is to
put,in individual cells :- =DAY(A1) =MONTH(A1) =YEAR(A1) or some other date value instead of A1. Regards BrianB =========================== "Roy Schultz" wrote in message ... I am using excel to fill in and print delivery receipts for merchandise. On one of the forms instead on one block for the date, there are three seperate ones for "Month", "Day", and "Year" I am using the WORKDAY function as the merchandise usually is delivered the day after the form is printed. Is there a way I can get Excel to display ONLY the Month, Day, and Year each in it's own cell?? Changing the form is not an option as they are specified, and provided by the vendor through whom the merchandise is being billed. Any help will be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Forms | Excel Discussion (Misc queries) | |||
Dates in forms | Excel Discussion (Misc queries) | |||
Forms | Excel Worksheet Functions | |||
forms | Excel Programming | |||
VB Forms | Excel Programming |