| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look Up
On the Summary tab I want to type 2010 YTD = [BLAH] into cell B2. I want the
Blah to represent the data currently in cell A2 on the Data Tab. How would I write this formula? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Look Up
Hi,
Like this ="2010 YTD " & TEXT(Data!A2,"dd/mm/yyyy") Change the date format to the one you want -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Pass-the-Reality" wrote: On the Summary tab I want to type 2010 YTD = [BLAH] into cell B2. I want the Blah to represent the data currently in cell A2 on the Data Tab. How would I write this formula? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Look Up
Hi Pass-the-Reality,
On the Summary tab I want to type 2010 YTD = [BLAH] into cell B2. I want the Blah to represent the data currently in cell A2 on the Data Tab. How would I write this formula? Like this perhaps? ="2010 YTD " & Data!A2 Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
