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

  • Thread starter Thread starter TJ
  • Start date Start date
T

TJ

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
 
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
 
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
 
Back
Top