| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Won't Read Cell Names
I have made a cell with the following formula
=C2 However, instead of placing the value in C2, it is reading "=C2" |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Won't Read Cell Names
The most likely culprit is that you have formatted that cell as Text.
Go to the Format menu, choose Cells, and there the Number tab. In the list, choose General (or some other format) and click OK. Cordially, Chip Pearson Microsoft MVP Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Sat, 20 Dec 2008 14:28:08 -0800, krum35 wrote: I have made a cell with the following formula =C2 However, instead of placing the value in C2, it is reading "=C2" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| read only cell | Excel Worksheet Functions | |||
| I need the cell to read 0 | Excel Discussion (Misc queries) | |||
| Cell names = sheet names | Excel Worksheet Functions | |||
| CAN YOU SET GRAPH TO READ, FORMULA IN A CELL AS A BLANK CELL | Excel Discussion (Misc queries) | |||
| read a column of names and place a number in the next cell | Excel Discussion (Misc queries) | |||
Linear Mode
