Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How change dimensions of data label text box in pie chart? | Charts and Charting in Excel | |||
Formatting a group of cells for text | Excel Discussion (Misc queries) | |||
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) |