D
DMS
Why is it that when enter a 0 (zero) it automatically gets changed to a - ?
How do i correct this problem?
How do i correct this problem?
G
Guest
Hi
It's the formatting that does that. Go to Format|Cells and change the format
to General
Andy.
It's the formatting that does that. Go to Format|Cells and change the format
to General
Andy.
D
dms2600
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.
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.
S
Sandy Mann
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
[email protected]
Replace @mailinator.com with
tiscali.co.uk
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
[email protected]
Replace @mailinator.com with
tiscali.co.uk