Problems: rounding & formatting Text/# combinations

G

Guest

060705 Problems: rounding & formatting Text/# combinations
is there an answer for, or need for ms to fix:

(excerpt from other posting)
I believe this to be a Huge problem in excel: not having a check box, where
I don't have to (80-0.5) on 1/2 the figures in every cell, thru-out the sheet.

people otherwise don't know it, conditional format colors / "numbers
viewed", are all off. In trying to quick visual scan a sheet: colors &
numbers are all "OFF".
Looking at 80 in 1 cell is green, the next it is red...

Is there a way to turn off rounding up / down in a sheet?

Number / Text Combination "Custom" formatting:
what else would have done, is for having examples of custom formatting,
numbers >100 <0 (see # signs) to be able to format x10 see 120.. stead of 12


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...a-dc520b93fc2c&dg=microsoft.public.excel.misc
 
G

Guest

ps: for text / numbers:

Number / Text Combination "Custom" formatting:
- is there a way to include examples (if exist), for text / number
combinations: removing text from? etc.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top