| 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) | |||
![me[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
