how do I remove the "0" in front of a decimal point?

[befuddled]

I'm trying to construct a correlation table, but every time I put in a value
that is not statistically significant a "0" pops in front of the decimal when
I press enter. Is there a way to stop this? I'm finding excel very easy to
use otherwise. I'd hate to start all over again.

Thanks,
Lynda, the befuddled

 

[Debra Dalgleish]

You can create a custom number format without the zero:

Select the chart data
Choose Format>Cells
On the Number tab, select the Custom category
In the text box, type: #.##
(add as many # after the decimal as you require)
Click OK

Jon Peltier has a page on Number Formats:

http://www.peltiertech.com/Excel/NumberFormats.html