| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
microsoft excel 2000 calculating problem
hi,
i have faced the following problem i entered 52.7 (A1)in a cell but it treated as character. i set this as number after that i put formula "=A1*2" but showed "#VALUE" in that cell . how can i get rid of this problem? bye amit |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
microsoft excel 2000 calculating problem
If you are saying that you typed the text string "52.7 (A1)" into a cell,
then formatting it as a number won't turn it into a number, it will still be text. If you want it as a number, you just need the 52.7 -- David Biddulph wrote in message ... hi, i have faced the following problem i entered 52.7 (A1)in a cell but it treated as character. i set this as number after that i put formula "=A1*2" but showed "#VALUE" in that cell . how can i get rid of this problem? bye amit |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Microsoft EXCEL 2000 Formula | Excel Worksheet Functions | |||
| MICROSOFT EXCEL NO LONGER CALCULATING FORMULAS | Excel Discussion (Misc queries) | |||
| Microsoft Excel 2000 | Excel Discussion (Misc queries) | |||
| Change individual cell heights/widths in Microsoft Excel 2000 like Microsoft Word | Excel Discussion (Misc queries) | |||
| Microsoft excel 2000 | Excel Worksheet Functions | |||
Linear Mode
