| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel
|
|||
|
|||
Convert random numbers to text..
HAPPY EVERYTHING!!
I have a problem and after searching for an answer for at least 3 hours I am stumped. I have a spreadsheet formatted as follows: Row B2 -- DT2 is the name of Regions. ColumnA3 down to A50 are products. In the cells to the left os A3.. and beneath each Region there are numbers ranging from 1-- 70000(sample). I need to replace all cells which have a value and are not empty with an 'X'. I then have a SQL script to extract that data in to a db. I have found many macros, scripts for converting to monetary values to text in just about any language, various vlookup and other conversion scripts but can not figure out how to do the above.. I would really appreciate any assistance!!!! TIA!! Raymond |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert text to numbers | Excel Discussion (Misc queries) | |||
| How do I convert numbers to text like bahttext but in sterling | Excel Worksheet Functions | |||
| Convert Numbers to Text | Excel Worksheet Functions | |||
| convert numbers to text. | Excel Worksheet Functions | |||
| Convert text to numbers | Excel Discussion (Misc queries) | |||
Threaded Mode
