Excel converts formula to number
Hi ...,
Sorry, certainly should have mentioned that in order to enter
text into a cell, it would be best to format the cells (and such
columns) as Text (format, cells, text). An alternative is
to precede the entry with a single quote.
==
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
"noyb" wrote in message
How come when I enter 10000/10 excel displays 1000 in the formula bar
|