If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Problems caused by numbers formatted as percentages
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. |
#3
|
|||
|
|||
Problems caused by numbers formatted as percentages
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. |
Thread Tools | |
Display Modes | |
|
|