##### means your column isn't wide enough for the data. ;-)
--
JoAnn Paules
MVP Microsoft [Publisher]
~~~~~
How to ask a question
http://support.microsoft.com/KB/555375
"Nospam" wrote in message
. ..
I'm using Excel 2002. I've created a spreadsheet of my weightlifting
workouts--dates, exercises, and in the cells, the number of sets I perform
with the number of repetitions. For instance, cells have numbers like
2-12, 2-9, 3-12, indicating two or three sets of 9 or 12 repetitions. The
problem is that I'm formatting the cells as general, but I'm still getting
a green triangle in the upper left cell corner, and when I hold the cursor
over the cell, the yellow exclamation point appears, asking me if I want
to ignore the formatting error. In some cells that I think I've already
formatted, my numbers turn to "###." I want to enter the numbers as plain
text with no other formatting. What am I doing wrong?
Also, what's the formatting difference between "general" and "text"
formatting?
Thanks. --Arthur