| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
i need the cells to read 9-1 and it won't work
Precede the 9-1 or 4-6 with an apostrophe or preformat the cells to Text.
=5+7+6+3 You need the "=" sign to let Excel know it is a formula. Gord Dibben MS Excel MVP On Wed, 14 May 2008 18:07:01 -0700, 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Read lines from one worksheet, if value is true, write to new work | Excel Discussion (Misc queries) | |||
| Can you set certain cells as read only? | Excel Discussion (Misc queries) | |||
| Help getting macro to work in read only | Excel Discussion (Misc queries) | |||
| trying to sum columns in which some cells read n/a | Excel Discussion (Misc queries) | |||
| my excel work book is NOT read onlyt says it is when saving to CD | Excel Discussion (Misc queries) | |||
Threaded Mode
