Thread: Custom Format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
me[_4_] me[_4_] is offline
external usenet poster
 
Posts: 4
Default Custom Format

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.