Problems caused by numbers formatted as percentages

I have a workbook created in Excel 2002. It consists of 2 worksheets and 1
chart. Certain cells in the first worksheet are formatted to display numbers
shown as percentages to one decimal place. The second worksheet reproduces
certain data from the first worksheet. The chart is produced from the data
in the second worksheet, which is needed because the data in it is organised
in a particular way in order to produce an unusual chart.

In reproducing the data from the first chart in the second chart, I have
merely used the formula =Sheet1!B17 (or whatever the appropriate cell in the
first worksheet was called). That has led to those cells in the second
worksheet which reproduce cells in the first worksheet formatted to display
numbers shown as percentages to one decimal place also displaying numbers
shown as percentages to one decimal place. Having such cells in the second
worksheet as the basis for the chart has caused me problems in the chart
display.

Is there some function which I can add to the formula =Sheet1!B17 (or
whatever the appropriate cell in the first worksheet was called) which would
cause the cell in the second worksheet to appear as an ordinary number to
one decimal place, rather than as a percentage to one decimal place? In
other words, the cell which in the first worksheet which displays, say,
15.7%, would instead display in the second worksheet simply as 15.7.

I posted the above query minutes ago. Almost immediately afterwards, a kind
person in the charting newsgroup responded to an earlier query of mine in
that newsgroup, telling me how to achieve what I wanted by altering my
chart. That means I needn't worry about altering the formula I am using in
my worksheet.

I apologise for bothering people in this newsgroup unnecessarily.



"Leslie" leslieunderscorekatz@agddotnswdotgovdotau wrote in message
...
I have a workbook created in Excel 2002. It consists of 2 worksheets and 1
chart. Certain cells in the first worksheet are formatted to display
numbers
shown as percentages to one decimal place. The second worksheet reproduces
certain data from the first worksheet. The chart is produced from the data
in the second worksheet, which is needed because the data in it is
organised
in a particular way in order to produce an unusual chart.

In reproducing the data from the first chart in the second chart, I have
merely used the formula =Sheet1!B17 (or whatever the appropriate cell in
the
first worksheet was called). That has led to those cells in the second
worksheet which reproduce cells in the first worksheet formatted to
display
numbers shown as percentages to one decimal place also displaying numbers
shown as percentages to one decimal place. Having such cells in the second
worksheet as the basis for the chart has caused me problems in the chart
display.

Is there some function which I can add to the formula =Sheet1!B17 (or
whatever the appropriate cell in the first worksheet was called) which
would
cause the cell in the second worksheet to appear as an ordinary number to
one decimal place, rather than as a percentage to one decimal place? In
other words, the cell which in the first worksheet which displays, say,
15.7%, would instead display in the second worksheet simply as 15.7.

Thank you for letting us know that the question is already closed, so we
didn't waste time on it. No apology necessary.

Jerry

Leslie wrote:

I posted the above query minutes ago. Almost immediately afterwards, a kind
person in the charting newsgroup responded to an earlier query of mine in
that newsgroup, telling me how to achieve what I wanted by altering my
chart. That means I needn't worry about altering the formula I am using in
my worksheet.

I apologise for bothering people in this newsgroup unnecessarily.