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

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Decimal Place goes crazy when using the "&" Sign. 4
format issues with decimal places 1
Automaticallychanging the number of decimal places displayed 5
Check for more than 2 decimal places 3
How do I 'SUM' a column corrected to 2 decimal places from 3 2
URGENT! Excel adding decimal places and #'s 1
How can I change the default number of decimal places in Excel? 1
h:mm to decimal value 4

Top