| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Custom Format Cell with Reference to another sheet
Hi
I know this somehow can be done, but having trouble understanding it. What I have is 2 sheets eg MISC ATB and MONTH ATB In a cell on the MONTH ATB I would like to have in a cell "GENERAL" & refencing a date on the MISC ATB sheet say A2 and this to be formatted as MMM-YYYY Thanking you and hoping you can help |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Custom Format Cell with Reference to another sheet
Try the below formula
="GENERAL " & TEXT('MISC ATB'!A2,"mmm-yyyy") -- Jacob "enna49" wrote: Hi I know this somehow can be done, but having trouble understanding it. What I have is 2 sheets eg MISC ATB and MONTH ATB In a cell on the MONTH ATB I would like to have in a cell "GENERAL" & refencing a date on the MISC ATB sheet say A2 and this to be formatted as MMM-YYYY Thanking you and hoping you can help |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Custom Format Cell with Reference to another sheet
Thanking you very much, the problem was that the original data was not
formatted as a date. Having typed you formula which was similar to what I was originally trying to do, made me look further. Thanks again "Jacob Skaria" wrote: Try the below formula ="GENERAL " & TEXT('MISC ATB'!A2,"mmm-yyyy") -- Jacob "enna49" wrote: Hi I know this somehow can be done, but having trouble understanding it. What I have is 2 sheets eg MISC ATB and MONTH ATB In a cell on the MONTH ATB I would like to have in a cell "GENERAL" & refencing a date on the MISC ATB sheet say A2 and this to be formatted as MMM-YYYY Thanking you and hoping you can help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| getpivotdata custom subtotal cell reference | Excel Worksheet Functions | |||
| Format Cell as custom type but data doesn't display like I custom. | Excel Discussion (Misc queries) | |||
| Carrying format with cell reference to another sheet. | Charts and Charting in Excel | |||
| relative cell reference in custom validation | Excel Discussion (Misc queries) | |||
| Reference Cell in custom format???? | Excel Discussion (Misc queries) | |||
Hybrid Mode
