| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change Month formula from column to column
I am sure this is an elementary question, but am really short on time to
research. How can I start with July-07 in A1 and in B1 show August-07? I should also state that I have another spreadsheet that is looking in A1 for the date format of 1/1/07 and in B2 as 8/1/07 etc...it's a process that already exists but I want the Month-Yr format as stated above. Thanks for the help! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change Month formula from column to column
Set A1 to July date, B1 to Aug date, highlight both cells and copy across as
required. "Jana" wrote: I am sure this is an elementary question, but am really short on time to research. How can I start with July-07 in A1 and in B1 show August-07? I should also state that I have another spreadsheet that is looking in A1 for the date format of 1/1/07 and in B2 as 8/1/07 etc...it's a process that already exists but I want the Month-Yr format as stated above. Thanks for the help! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change Month formula from column to column
Cutsom Format as "mmm-yy"
"Jana" wrote: I am sure this is an elementary question, but am really short on time to research. How can I start with July-07 in A1 and in B1 show August-07? I should also state that I have another spreadsheet that is looking in A1 for the date format of 1/1/07 and in B2 as 8/1/07 etc...it's a process that already exists but I want the Month-Yr format as stated above. Thanks for the help! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change Month formula from column to column
Worked! Thanks so much for the help!!!! I love this website!
"Jana" wrote: I am sure this is an elementary question, but am really short on time to research. How can I start with July-07 in A1 and in B1 show August-07? I should also state that I have another spreadsheet that is looking in A1 for the date format of 1/1/07 and in B2 as 8/1/07 etc...it's a process that already exists but I want the Month-Yr format as stated above. Thanks for the help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I change column numbers back to column letters? | Excel Worksheet Functions | |||
| Formula for Extracting Month out of a Date column | Excel Discussion (Misc queries) | |||
| How do I change column into lines on a Line-Column chart? | Charts and Charting in Excel | |||
| Change the width of a single column in a column chart | Charts and Charting in Excel | |||
| Why does a formula change when I sort a column | Excel Worksheet Functions | |||
Linear Mode
