Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell to read exactly what I put in cell
I am trying to put numbers in the cells that have a dash in them. For
example 9-1, or 4-6. Everytime I do it it changes to a date or some other random number. I tried every format and can't figure it out. HELP?? PLEASE?? Also how do I make a cell format to put in the total value of a simple math problem. For instance, i put in the cell 5+7-6+3 but it reads the answer |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell to read exactly what I put in cell
To have 9-1 display without autoformatting to date, type in '9-1 (the
apostrophe will not display in the cell, it's a formatting character) or format the cell as text before data entry. To enter a math problem and see the result in the cell, preceed with an equal sign: =5+7-6+3 "TJ" wrote: I am trying to put numbers in the cells that have a dash in them. For example 9-1, or 4-6. Everytime I do it it changes to a date or some other random number. I tried every format and can't figure it out. HELP?? PLEASE?? Also how do I make a cell format to put in the total value of a simple math problem. For instance, i put in the cell 5+7-6+3 but it reads the answer |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to read the value of a cell | Excel Worksheet Functions | |||
Read part of a cell | Excel Discussion (Misc queries) | |||
How to use If statement to read a value in a cell | Excel Discussion (Misc queries) | |||
CAN YOU SET GRAPH TO READ, FORMULA IN A CELL AS A BLANK CELL | Excel Discussion (Misc queries) | |||
"read only" cell in a given worksheet | Excel Discussion (Misc queries) |