What's in the cell?

If you really have the text: "03 Aug 85.00 (DAV TG-E)", then I don't think you
can do it. Numberformat works on numbers--not text.



me wrote:

Hello,
I would like to Custom Number format the
"03 Aug 85.00 (DAV TG-E)" to appear like "85".
I can use the 'MID'Function in the formula to
do that.But,Since I want to use the cell for
'MATCH'Function ,I would like to use the format.
Any help,thanks.

--

Dave Peterson