| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
removing symbols from numbers
Hello,
I have a problem with removing objects from numbers. The first problem is that I would like to remove a # symbol and just get the real value. For example I have values of #4 and #15 and would like it to read just 4 and 15. The other problem is that I have numbers such as 185/10 and 45/0 and so forth. I would only want the whole value 185 and 45 and not the symbol / or anything after it. Can you help me. Thank you Chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cant read my excel, its just jumble of numbers and symbols!!!help! | New Users to Excel | |||
| Symbols instead of numbers | Excel Discussion (Misc queries) | |||
| manipulating cells with symbols and numbers | Excel Worksheet Functions | |||
| alphabetical sort while ignoring preceeding numbers/symbols | Excel Discussion (Misc queries) | |||
| Numbers instead of symbols on scatter chart | Charts and Charting in Excel | |||
Hybrid Mode
