zeros are being added to my numbers

D

des

Hi when i type a number into a cell ie 6 when i leave the cell a zero is
automatically added. I dont want this zero to be added
 
N

Niek Otten

In front or at the end?

Check:

a. Tools|Options|Edit tab, uncheck Fixed Decimal
b. Format the cell as General


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi when i type a number into a cell ie 6 when i leave the cell a zero is
| automatically added. I dont want this zero to be added
| --
| des
 

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

How to remove external organization from Office. 0
Adding recognised Zeros 5
Shared Link is showing empty notebook 1
Images are pixelated when saving to PDF 0
Formating bolded text exclusively. 0
Auto-Numbering in a Table in MS Word 1
Mail Merge Directory Conditional Page Break 0
Leading Zeros; How to Keep ? 2

Top