zeros are being added to my numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top