| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
limiting values shown in cell
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I ensure that in a chart zero(0) values are not shown ? | Charts and Charting in Excel | |||
| limiting the viewable space to the data shown | Excel Worksheet Functions | |||
| Column of Text Shown = Total Times Shown? | Excel Worksheet Functions | |||
| limiting cell value | Excel Discussion (Misc queries) | |||
| Named Ranges shown (or not shown) as blue means what? | Excel Worksheet Functions | |||
Threaded Mode
