limiting values shown in cell

[stacy05]

I have a spreadhseet of numbers that the user inputs. That spreadsheet is
linked to another sheet in the workbook to create a chart. To control the
scale I only want transfer the value of the 'thousands'....

examplein $$)
user input: $517,420 --->transfers to chart data sheet as : 517
user input: $19,872 --->transfers to chart data sheet as : 20
user input: $1,318,972 --->transfers to chart data sheet as : 1319

I know there is a way to do this, but obviously I am stumped!
Thanks in advance for any help!

 

[Mike H]

Hi,

Maybe this

=ROUND(A1/1000,0)

Mike

 

[Conan Kelly]

Stacy,

I would leave the amounts in the chart data sheet as is.

I would change the format of the amount/currency axis of the chart. Give it
a custom number number format of "#,##0,". With this custom format, 517,420
will DISPLAY as 517 (WILL DISPLAY AS.... the actual value will still be
517,420 in case you need to use the actual value in calculations elsewhere)
and 1,318,972 will display as 1,319.

You can also format the value cells on the chart data sheet with the same
format if you desire.

HTH,

Conan