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 |
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) |