Custom Format

M

me

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Table of content - format does not get saved 2
Outlook 365 overriding formatting choices 0
MS Project Center-Autolink column fields 0
ASK Field Formatting 1
Word VBA - Want to test if Full Name is NOT Present in document 0
Formula to fill cells based on Date of Arrival and Date of Departure 1
How can the font and size of (all) citation numbers be altered? 1

Top