Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problems: rounding & formatting Text/# combinations
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/comm...lic.excel.misc |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problems: rounding & formatting Text/# combinations
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. "nastech" wrote: 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/comm...lic.excel.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems changing cell formatting | Excel Discussion (Misc queries) | |||
How change dimensions of data label text box in pie chart? | Charts and Charting in Excel | |||
Formatting Cell to text | Excel Discussion (Misc queries) | |||
Conditional Formatting based on Text within Text | Excel Discussion (Misc queries) | |||
Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) |