zeros are being added to my numbers

[Guest]

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

 

[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

 

[Guest]

Hi Niek Otten your fix worked Thanks