ExcelBanter - Custom Format

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Custom Format (https://www.excelbanter.com/excel-programming/274516-custom-format.html)

me[_4_]

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.

Dave Peterson[_3_]

Custom Format

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

All times are GMT +1. The time now is 12:03 AM.