In front or at the end?
Check:
a. Tools|Options|Edit tab, uncheck Fixed Decimal
b. Format the cell as General

Signature
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 - 25 Nov 2006 19:15 GMT
Hi Niek Otten your fix worked Thanks

Signature
des
"Niek Otten" wrote:. Hanks
> In front or at the end?
>
[quoted text clipped - 5 lines]
> | 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