Why is it that when enter a 0 (zero) it automatically gets changed to a - ?
How do i correct this problem?

Hi
It's the formatting that does that. Go to Format|Cells and change the format
to General

Andy.

"DMS" wrote in message
...
Why is it that when enter a 0 (zero) it automatically gets changed to a -
?
How do i correct this problem?

This is not the problem. Even if I enter a 0 in a formula it automatically
changes to a -. I have spent a great deal of time trying to figure out why.
It does not appear to be related to formatting.

"Andy" wrote:

Hi
It's the formatting that does that. Go to Format|Cells and change the format
to General

Andy.

"DMS" wrote in message
...
Why is it that when enter a 0 (zero) it automatically gets changed to a -
?
How do i correct this problem?

What do you see in the formula bar? If it is a zero then most probably th
cell has been formatted as currency with no currency symbol or decimal
places. If you only see a dash then check Autocorrect in Tools
Autocorrect to see if it is being changed there. If that is the reason then
look around the office to see who is smiling.

HTH

--
Sandy



Replace @mailinator.com with


"
wrote in message ...
This is not the problem. Even if I enter a 0 in a formula it automatically
changes to a -. I have spent a great deal of time trying to figure out
why.
It does not appear to be related to formatting.

"Andy" wrote:

Hi
It's the formatting that does that. Go to Format|Cells and change the
format
to General

Andy.

"DMS" wrote in message
...
Why is it that when enter a 0 (zero) it automatically gets changed to
a -
?
How do i correct this problem?