cell formating + vlookup

[andrewurq]

I have a vlookup that I am trying to clean. It evaluate a column that contains things like 100000. Only that 100000 is a text format not a number format. I have to keep it in a text format because that is the way my spreadsheet is pulling data from an ODBC server that has preset queries and tables. if the 100000 is in text format my vlookup works fine, in other formats it does not. I set up a macro to auto covert all my cells over to text, however it doesn't seem to actually update until I click into the specific cell and then click out. My spread sheet should never be more than 500 - 1000 lines long should I do some sort of loop to select all cells in my specific column with data? What would that look like? Any other suggestions?



I tried the below to no avail:




You can try this:

Select an empty cell
edit|copy
select that column of text "numbers"
edit|paste special|check Add

And apply [FONT=inherit !important][FONT=inherit !important]the [/FONT][FONT=inherit !important]format[/FONT][/FONT] one more time.

DKY wrote:
>
> I set up a column with 527 rows as a date formatting but the formatting
> doesn't work until I click in the actual cell, then click in the
> formula bar up top and then hit the checkmark to the left of it. Then
> the formatting works, but I don't want to have to do that with every
> cell. Is there a way around that? I tried F9 and that doesn't help
> either.
>