Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
custom formatting
I have never really understood how the custom formatting works with basic
numbers. Can anyone explain (or point me to somewhere that explains what things like the following "language" are are saying: _($* #,##0_);_($* (#,##0);_($* "-"??_);_(@_) this is just an example, but I'd like to be able to understand them all. Thanks. -- Boris |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
custom formatting
for my immediate needs, I need for a cell to take a number input
(representing a whole percent), and display it as a "+"/"-" if positive/negative, then the number with no decimal, "%" sign, and then either the word "growth" or "decline" depending on positive or negative. Possible? -- Boris "BorisS" wrote: I have never really understood how the custom formatting works with basic numbers. Can anyone explain (or point me to somewhere that explains what things like the following "language" are are saying: _($* #,##0_);_($* (#,##0);_($* "-"??_);_(@_) this is just an example, but I'd like to be able to understand them all. Thanks. -- Boris |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
custom formatting
In Excel Help, lookup the topic "Guidelines for custom number formats",
which gives a detailed explanation of the various format characters and codes and how they are used. For your format, you probably just want +0% "growth";-0% "decline";0;_(@_) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "BorisS" wrote in message ... for my immediate needs, I need for a cell to take a number input (representing a whole percent), and display it as a "+"/"-" if positive/negative, then the number with no decimal, "%" sign, and then either the word "growth" or "decline" depending on positive or negative. Possible? -- Boris "BorisS" wrote: I have never really understood how the custom formatting works with basic numbers. Can anyone explain (or point me to somewhere that explains what things like the following "language" are are saying: _($* #,##0_);_($* (#,##0);_($* "-"??_);_(@_) this is just an example, but I'd like to be able to understand them all. Thanks. -- Boris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Formatting Custom Number | Excel Discussion (Misc queries) | |||
make custom formatting permanent | Excel Worksheet Functions | |||
Custom Formatting for Dates | Excel Discussion (Misc queries) | |||
Custom charts - default formatting | Charts and Charting in Excel | |||
Custom formatting to force a decimal place | Excel Discussion (Misc queries) |