Prev: Formula for multiple criteria on 2 worksheets
Next: Conditional Formatting In and Across Sheets
From: Doug on 27 May 2010 16:52
Why would I show zero's for a column of data in my chart that are actually
very large(56869685). Some of my charts have date segments that are missing
when the data is there in the table? I checked the formatting for the data in
the table and it is all set to a number, no decimal format. I don't
understand?
--
Thank you!
From: Jon Peltier on 28 May 2010 14:14
The numbers may have been entered as text, even if the cells are now
formatted as numbers. You can tell by clicking the Add Decimal button.
If no decimal digit is added, it's text.

To fix, select the column of data, and use Text to Columns with settings
that won't split any of the cells into more than one column. This
function converts text into numbers.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 5/27/2010 4:52 PM, Doug wrote:
> Why would I show zero's for a column of data in my chart that are actually
> very large(56869685). Some of my charts have date segments that are missing
> when the data is there in the table? I checked the formatting for the data in
> the table and it is all set to a number, no decimal format. I don't
> understand?
 | 
Pages: 1
Prev: Formula for multiple criteria on 2 worksheets
Next: Conditional Formatting In and Across Sheets