Can't change data table in Microsoft 2007

I have a graph in microsoft 07 and the data table is in numbers that are rounded up the the next whole number. (so 456.78, is 457) When i copy the graph to another spreadsheet it keeps the 456.78 and I can't change the number of decimal places to "0". I can change it to 1 or 2 or 3, but not 0. Can anyone help me out. I want to present the graph and it looks cleaner with 0 decimal places.

Thanks,

Originally Posted by Coors

I have a graph in microsoft 07 and the data table is in numbers that are rounded up the the next whole number. (so 456.78, is 457) When i copy the graph to another spreadsheet it keeps the 456.78 and I can't change the number of decimal places to "0". I can change it to 1 or 2 or 3, but not 0. Can anyone help me out. I want to present the graph and it looks cleaner with 0 decimal places.

Thanks,

Well, I have made some progress. If I have both files open, the data table will have 0 decimal places. When I close the original file, the second file will automatically change to 2 decimal places. Anyone have a clue how to stop this?