format number

  • Thread starter Thread starter CB
  • Start date Start date
C

CB

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?
 
Have you thought about just using an extra column?

Use one column for the value to display and one column for the value to chart.
 
Hi Dave,
I had already thought of this, however was hoping that the format number
would allow this formating as well.
Thanks,
CB
 
Hi Dave,
I had already thought of this, however was hoping that the format number
would allow this formating as well.
Thanks,
CB
Click to expand...

As far as I know, formatting does not allow this style.
--ron
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA text Box 1
Custom Number Format for text 8
Use a combo to change the data range for a chart? 1
Sorting numbers the common sense way excell03 4
Excel Macro to automatically go to the right of the last colored cell 0
simple formula I'm sure using offset? or index? 2
Help with Formula 2
Question about conditional formatting of zeros in Excel 0

Back
Top