Hi Dave,
I had already thought of this, however was hoping that the format number
would allow this formating as well.
Thanks,
CB

"Dave Peterson" wrote:

You could even hide the column that's used for charting.

CB wrote:

Is is possible to format cells to drop the last digit of a number yet keep
the value?

If I have a cell that contains 220, I want the cell to display 22, yet I
want to be able to chart the value of 220.

Can this be done?

--

Dave Peterson