| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
formula
Dear all,
When I enter "=A2" for example into a sheet it stayes as =A2 instead of bringing the data. Can anyone explain this please? XP Pro SP2 Excel 2003 John North Yorkshire UK |
|
#2
|
|||
|
|||
|
My guess is that the cell is formatted as text. Go to Format, Cells, Number.
Under Category click General and then click OK. Then retype =A2. Hopefully this will fix it. "John Proud" wrote: Dear all, When I enter "=A2" for example into a sheet it stayes as =A2 instead of bringing the data. Can anyone explain this please? XP Pro SP2 Excel 2003 John North Yorkshire UK |
|
#3
|
|||
|
|||
|
Well done Martin.
Just when you think you have everything sorted - you learn some more! Cheers John "Martin P" wrote in message ... My guess is that the cell is formatted as text. Go to Format, Cells, Number. Under Category click General and then click OK. Then retype =A2. Hopefully this will fix it. "John Proud" wrote: Dear all, When I enter "=A2" for example into a sheet it stayes as =A2 instead of bringing the data. Can anyone explain this please? XP Pro SP2 Excel 2003 John North Yorkshire UK |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
| Simplify formula | Excel Worksheet Functions | |||
| put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
| how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Linear Mode
