Once more I've encountered a problem apparently caused by programmers not
paying attention to the users. I have a spreadsheet that MUST show the signs
(+/-) of a number. For one series, the unit MUST also show. So, positive
numbers MUST be shown as +##.### and negatives as -##.###. When units are
shown, the format MUST be +##.### lbs. and -##.### lbs. What's especially
aggravating is when I enter -##.### lbs., Excel assumes it's a formula, not
text. (This coding is only slightly less aggravating than Excel assuming
entering 234 + 456 is text, not a formual. At least Quattro Pro got that
right.)
Any suggestions?
--
I know enuff to be dangerous.