Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Number Stored as text Error
I'm trying to write a macro but one column show those little green things
that shows that I have an Error (Number Stored as text ). I don't know a lot of VB so I'm recording and touching here and there the VB. I cannot record the comand that changes it to number when I click in the little thing in the cell that contains the error. If I go to format cell and change it to number the error stays there. The problem is that if I have that error VLOOKUP does not work properly. Does anybody could understand what I tried to say? Can somebody help me? Thanks, Marcelo |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Number Stored as text Error
And are you going to show us the VBA code that puts this data into the
cells? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Torero" wrote in message ... I'm trying to write a macro but one column show those little green things that shows that I have an Error (Number Stored as text ). I don't know a lot of VB so I'm recording and touching here and there the VB. I cannot record the comand that changes it to number when I click in the little thing in the cell that contains the error. If I go to format cell and change it to number the error stays there. The problem is that if I have that error VLOOKUP does not work properly. Does anybody could understand what I tried to say? Can somebody help me? Thanks, Marcelo |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Number Stored as text Error
ActiveCell.FormulaR1C1 = "=LEFT(RC[-1],LEN(RC[-1])-1)"
Range("D2").Select Selection.AutoFill Destination:=Range("D2:D10000") Range("D2:D10000").Select Application.CutCopyMode = False Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False I have a column with PN's that has one digit in the end, so I using a formula to take that digit of and I'm pasting it as value. I hope this clarify what I'm trying to do. "Bernard Liengme" wrote: And are you going to show us the VBA code that puts this data into the cells? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Torero" wrote in message ... I'm trying to write a macro but one column show those little green things that shows that I have an Error (Number Stored as text ). I don't know a lot of VB so I'm recording and touching here and there the VB. I cannot record the comand that changes it to number when I click in the little thing in the cell that contains the error. If I go to format cell and change it to number the error stays there. The problem is that if I have that error VLOOKUP does not work properly. Does anybody could understand what I tried to say? Can somebody help me? Thanks, Marcelo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting the number of decimal places for a text box. | Excel Discussion (Misc queries) | |||
Numbers stored as text causes problem with VLOOKUP | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Change number format from text to number? | New Users to Excel | |||
Number stored as text | Excel Discussion (Misc queries) |