Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format to text was not sufficient
Bruce
Try this. Sub aaa() Range("h65536").End(xlUp).Select While ActiveCell.Row 11 If WorksheetFunction.IsNumber(ActiveCell.Value) Then ActiveCell.Value = "'" & ActiveCell.Value End If ActiveCell.Offset(-1, 0).Select Wend End Sub Tony -----Original Message----- I have a column of 400 rows or so of data where the characters are all numbers but the field I'm uploading to is alpha. Formatting these entries as text does now work in this situation. Example below: 52006000 would be entered as '52006000 So, what I need is to convert an undetermined number of cells in a column. I need the macro beginning in cell h12 in this case and it needs to figure out how many rows there are from there on down so that it will have a stop value. Then I would need a for loop that would go into each cell. It would need to add the apostrophe at the beginning of the cell entry in the fashion shown above if it is not already there. Thanks for your help... Bruce . |
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 | |||
Vlookup not sufficient - suggestions for combining multiple matche | Excel Worksheet Functions | |||
Merge files blocked by change history and "sufficient amount of ti | Excel Discussion (Misc queries) | |||
VLOOKUP/ SUMIF not sufficient | Excel Discussion (Misc queries) | |||
VLOOKUP is not sufficient | Excel Worksheet Functions |