Or if you think it will ever contain letters and digits then you could
try -

=LEFT(A1,LEN(A1)-4)

Ger

macropod wrote:
Hi charlene,

For a value in A1,
=INT(A1/10000)
deletes the 4 right digits.

Cheers

--
macropod
[MVP - Microsoft Word]


"charlene" wrote in message
...
is it possible to delete the 4 rightmost digit of a cell ?