I use XL97 and Windows 2000. Try this:

In cell A1, put 13547.
In cell B1, put =LEN(A1). It returns 5, which I would expect.
In cell C1, put =RIGHT(A1,LEN(A1-2)). This returns 13547, which I would
NOT expect.

Why doesn't it return 547?