Hi,

Maybe this

=ROUND(A1/1000,0)

Mike

"stacy05" wrote:

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'....

example:(in $$)
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!