| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text to Value
Hi. I have a column of numbers. Before my code executes, I would like to
check the column to make sure all numbers are truly numbers. Every so often a number slips in with a ' in front of it, making it text. Is there a simple way to remove the ' in cells where it occurs? I tried to use edit/replace, but MS said it could not find the '. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using TEXT and &TEXT - display numbers with commas, underline text | Excel Discussion (Misc queries) | |||
| Sumif text is contained winthin a longer text string in a cell | Excel Worksheet Functions | |||
| Text does not display in "Text boxs" and when wrapping text in a c | Excel Discussion (Misc queries) | |||
| Excel VBA: Worksheet cell .Text property: 1024 bytes text len limit | Excel Programming | |||
| extracting text from within a cell - 'text to rows@ equivalent of 'text to columns' | Excel Programming | |||
![Steph[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
