Formatting numbers
Can't help you with charting, but if your version of XL is later then XL97,
you could try this custom format:
[=1]#,###;#%
You must also go to:
<Tools <Options <Edit tab,
And make sure that "Enable Auto Percent Entry"
is *UNCHECKED*
This will display numbers *less* then 1 as percents, and all others as
regular numbers without decimals.
If you think that there might be a possibility that you might have values of
100%, then change the format to this:
[1]#,###;#%
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"avjunior" wrote in message
...
Sorry, let me add something....
I also would like to have the "y" axis of the graph, changing format
according to the results as well (e.g. %, 0,000, etc).
thanks
"avjunior" escreveu:
Let's suppose I have 2 sheets in a worksheet.
Sheet 1 is a entry form (dropbox for example)
The source of the dropbox are fields of numbers in different
formats
(e.g: %; 0,000, etc)
Sheet 2
This is where the numbers are going to after the user selection. So
I
would like to have, for example the following results:
result a)
BRANCH TOTAL
A 1,000
B 45,000
result b)
BRANCH PERCENTAGE
A 44%
B 51%
Note that in result a) I need the cells to be formated as 0,000 and
result
b) I want the cells formated as %.
So the question is:
How can I have a cell change its number format based on a condition?
thanks
|