ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cells not holding format (https://www.excelbanter.com/excel-discussion-misc-queries/16879-cells-not-holding-format.html)

Aurora

Cells not holding format
 
I am using Excell 2000

Every month I receive excell created charts with data via
e-mail. I then copy these charts to another excell file
so that we now have 1 file with approximately 22 charts on
11 pages.

Here is my problem. I copy a chart that has numbers in
the ledgend in the bottom of the chart. The original
chart is formated as "number with 2 places". I copy the
chart and everything looks good. The numbers read as they
should - Ex: 9.99 or 7.25 etc. But when I close the
original chart, some of the numbers in the ledgend change
to 9.988888 or to 7.253333. How do I keep the numbers in
the copied chart to read the same way they do in the
original chart? HELP!!

Aurora




All times are GMT +1. The time now is 10:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com