| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data from another cell
Does anyone know why when I use the equal (=) sign to get data from another
cell in another worksheet it just gives me the cell name: i.e. =targetdateC2. and not the actual data which is 2x. I tried manually calculating to no extent. Thanks Frank |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Data from another cell
Is the cell formatted as Text? Try changing the format to General.
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Beep Beep" wrote in message ... Does anyone know why when I use the equal (=) sign to get data from another cell in another worksheet it just gives me the cell name: i.e. =targetdateC2. and not the actual data which is 2x. I tried manually calculating to no extent. Thanks Frank |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Data from another cell
Thanks Bob
Learn something new everyday Frank "Bob Phillips" wrote: Is the cell formatted as Text? Try changing the format to General. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Beep Beep" wrote in message ... Does anyone know why when I use the equal (=) sign to get data from another cell in another worksheet it just gives me the cell name: i.e. =targetdateC2. and not the actual data which is 2x. I tried manually calculating to no extent. Thanks Frank |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Data from another cell
If you are manually entering the formula you need the ! inserted.
=targetdate!C2 If you are letting Excel enter the reference it should be no problem. Enter the = sign then switch to other sheet, select C2 and hit ENTER key Gord Dibben MS Excel MVP On Thu, 5 Jul 2007 08:12:05 -0700, Beep Beep wrote: Does anyone know why when I use the equal (=) sign to get data from another cell in another worksheet it just gives me the cell name: i.e. =targetdateC2. and not the actual data which is 2x. I tried manually calculating to no extent. Thanks Frank |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i find specific data in a cell and its colocated cell data | Excel Worksheet Functions | |||
| converting numerical data in one cell to word data in another cell | Excel Worksheet Functions | |||
| how to find number in a cell , a cell contains character data ornumeric data | Excel Worksheet Functions | |||
| Find MAX data in sheet (Cell) - Any cell that exceeds X amount of data | Excel Discussion (Misc queries) | |||
| data validation to restrict input in cell based on value of cell above that cell | Excel Programming | |||
Linear Mode
