Excel defaulting to 3 decimal places when using the gen. format
 

I have a problem when entering numerical values in cells that have been
formated to general. Somehow the cells seem to be formatted using 3 decimal
places automatically even though I don't want decimal places. Entering 123
gives me a .123. Entering 1234 gives me 1.234. I believe that I may have set
up a macro to automatically default all values to 3 decimal places. It is now
affecting all my excel files. I can't call up the macro and delete it.
Attempting to reformat the cells doesn't help.

It automatically affects any new workbooks that I create.

Can anyone suggest what I can do? Thanks.

go to< tools< options < edit
and deselect <fixed decimal places<

--
Greetings from New Zealand
Bill K
"cprtrain" wrote in message
...
I have a problem when entering numerical values in cells that have been
formated to general. Somehow the cells seem to be formatted using 3
decimal
places automatically even though I don't want decimal places. Entering 123
gives me a .123. Entering 1234 gives me 1.234. I believe that I may have
set
up a macro to automatically default all values to 3 decimal places. It is
now
affecting all my excel files. I can't call up the macro and delete it.
Attempting to reformat the cells doesn't help.

It automatically affects any new workbooks that I create.

Can anyone suggest what I can do? Thanks.