Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help with converting CUSTOM format/TEXT format to DATE format | Excel Worksheet Functions | |||
Format Cell as custom type but data doesn't display like I custom. | Excel Discussion (Misc queries) | |||
Excel 2003. Custom format gets replaced by Special format. | New Users to Excel | |||
ignore auto format after applying a custom format?? | Excel Discussion (Misc queries) | |||
how do I add phone number format as a permanent custom format? | Excel Discussion (Misc queries) |