i need the cells to read 9-1 and it won't work
 

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

i need the cells to read 9-1 and it won't work
 

Did you apply a text format to the cells prior to entering the hyphenated
number? This should work. So should entering an apostrophe in front of the
entry, '9-1.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"TJ" wrote in message
...
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

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