Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003 Functions
Hi - I cannot call a value from another cell. For example, I have the no.
'22' entered into cell range A1. If I click in another cell and call the value using a forumla of =(A1), the value '22' doesn't appear in the cell =(A1) appears. I'm sure there must be a simple option that I have neglected to select, or it's an installation issue. Please help! Carl |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003 Functions
Hi Carl,
Two options: a.The cell was formatted as text before you entered the formula. Format as General AND re-enter the formula (F2, ENTER) b. Formula view was toggled on. Hit CTRL` to toggle off -- Kind regards, Niek Otten Microsoft MVP - Excel "Carl Fenty" wrote in message ... | Hi - I cannot call a value from another cell. For example, I have the no. | '22' entered into cell range A1. If I click in another cell and call the | value using a forumla of =(A1), the value '22' doesn't appear in the cell | =(A1) appears. I'm sure there must be a simple option that I have neglected | to select, or it's an installation issue. | | Please help! | | Carl |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003 Functions
Hi - I have tried both options, neither has worked. If I change the format
to general or number, a value of '0' is returned left justified. Any other ideas? "Carl Fenty" wrote: Hi - I cannot call a value from another cell. For example, I have the no. '22' entered into cell range A1. If I click in another cell and call the value using a forumla of =(A1), the value '22' doesn't appear in the cell =(A1) appears. I'm sure there must be a simple option that I have neglected to select, or it's an installation issue. Please help! Carl |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003 Functions
After changing the format to General, you must re-enter the formula.
Hit F2 then ENTER Gord Dibben MS Excel MVP On Thu, 2 Nov 2006 04:13:02 -0800, Carl Fenty wrote: Hi - I have tried both options, neither has worked. If I change the format to general or number, a value of '0' is returned left justified. Any other ideas? "Carl Fenty" wrote: Hi - I cannot call a value from another cell. For example, I have the no. '22' entered into cell range A1. If I click in another cell and call the value using a forumla of =(A1), the value '22' doesn't appear in the cell =(A1) appears. I'm sure there must be a simple option that I have neglected to select, or it's an installation issue. Please help! Carl |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening Excel 2003 files in Excel 97 | Excel Discussion (Misc queries) | |||
External Links on open and Excel 2003 | Excel Discussion (Misc queries) | |||
Help in Excel 2003 | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) |