Not a formula, but a procedure.

Sub find()
Dim myPos As Long
Dim myrng As String
myrng = Range("A1").Value
myPos = InStrRev(myrng, "0")
End Sub

This returns 10 as the position of the last 0 in your example.

Mike F
"delmac" wrote in message
...
HI all I have a column of numbers that includes o such as 0045a
078
009. Is there are formula that enables me to find the first 0 from the
right. Thanks for all your help on this and previuos requests.
--
delmac