Answer sent by private mail
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Bernard Liengme" wrote in message
...
It has not arrived. Try sending to

use bliengme in place of bl
(We have to do this to prevent spam!)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Paul" wrote in message
...
I just emailed that to you. This problem seems to be occurring with any
trailing zeros. Again, thanks for you assistance with this.

"Bernard Liengme" wrote:

Hi Paul,
I cannot reproduce this in XL 2007.
Tell us what is in the cell with value 2.5. Is it a number or a formula?
You may wish to send me the file ( not to the newsgroup but to my
private
email address - remove TRUENORTH)
best wishes
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Paul" wrote in message
...
I'm using Excel 2007, and have created a Line Graph with a Data Table
below
the graph. The issue is that the Number Formatting is fine with
numbers
like
2.53 and 2.58, but the number formatting shows the number of 2.50 as
2.5.
It
cuts off the trailing zero for this and only this number in the table.
The
source data says "2.50", and all other numbers show two digits to the
right
of the decimal point. I've tried a few things, but to no resolution.
How
can I fix this so my data table give two digits to the right of all
numbers?