| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert range of text to values
Hello,
How do you convert text (with a macro) to values in a large range of cells? The spreadsheet always has a range (C25:AJ255) with the numbers sent as text. I need to change them all back to values so I can work with them. I would really appreciate your help. Thank you very much. Jill |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I take a string of text and convert it ASCII Values? | Excel Discussion (Misc queries) | |||
| How to convert text into range reference? | Excel Worksheet Functions | |||
| Convert Data Range in to individual values | Excel Discussion (Misc queries) | |||
| Convert text in cell to a range name for formula | Excel Worksheet Functions | |||
| convert a range of lowercase text to upper text or vice versa | Excel Worksheet Functions | |||
![Jill[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
