Lynda -
Did you get David's point about formatting the number? You can make it look
like it's 1/1000 of its value, but the value is retained internally. You can
read a little bit about Excel's number formats he
http://peltiertech.com/Excel/NumberFormats.html
I admit I didn't really understand from your description what your problem
really was.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"Lynda" wrote in message
...
Thank you for your response David. Can i give you a scenario?
This month we used 1400 items
We were allowed to use 1700
It cost us $1,234,567.00 which we reduce to 1234.567
So far this year it has cost us $3,456,789.00 which we reduce to 3456.789
They also receive a seperate table with the whole numbers on it but in the
graph and accompanying data this is how they want us to report it so a
good
employee does as the boss requests. I know in this instance it is only
manually changing 2 numbers but when you have masses of different data to
input into lots of different tables it would be nice to be able to set
things
up to happen automatically if possible.
"David Biddulph" wrote:
Why did you decide to convert to 3 decimal places and divide the number
by
1000? What's wrong with just formatting with zero decimal places?
--
David Biddulph
"Lynda" wrote in message
...
I have a number of different worksheets that I input data to for
different
periods. My number 1 sheet has my graph and data table that I print for
my
report. All my sheets are set to automatically link to my number 1
sheet.
My
problem is that in one of my worksheets I am using whole numbers eg:
1,234,567.00. Of course to have this whole number fit into the rest of
my
graph I need to convert it to 3 decimal places eg: 1,234.567. In the
data
table under my graph I have formatted the cell to accept 1,234.567 and
this
is how you see it. Unfortunately the graph still sees it as
1,234,567.00
which has the column in the graph going way off the page. It seems the
only
way around this is to break the link and manually type the number in. I
am
hoping this makes sense and perhaps someone can show me the magic
trick.