| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
need help in adding a ' in front of a column of numbers
Start with:
http://www.mvps.org/dmcritchie/excel/getstarted.htm -- Gary''s Student - gsnu200804 "noreaster" wrote: That worked out great, Thank you so much. Most of the code I understand. What sites do you recommend for learning for newbies and definitions? "Gary''s Student" wrote: Select the cells you want to change and run this macro: Sub dontquoteme() Dim s As String Dim cell As Range s = Chr(39) For Each cell In Selection cell.Value = s & cell.Value Next End Sub -- Gary''s Student - gsnu200804 "noreaster" wrote: From what I read, a macro does not recored keystrokes. I'm new at this so bear with me. I have found out that I can make numbers read as text by adding a ' in front of the number Exa, '3331 '3331-6 '3331-25 so after doing a sort as text the numbers will be in proper order. I have a column of part numbers that I need to add a ' in front of the number so it will sort the way I want. I am using excel 2003. TIA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ADDING NUMBERS IN A COLUMN | New Users to Excel | |||
| adding numbers from column B, while condition on column A | Excel Discussion (Misc queries) | |||
| adding digits to front/end of fax numbers | Excel Discussion (Misc queries) | |||
| adding a zero in front of number | Excel Discussion (Misc queries) | |||
| Adding + in front of a number | Excel Discussion (Misc queries) | |||
Threaded Mode
