Vlook Up not recognising Numbers

[craig white]

I have a 60000 row document where the ID is numeric. When i download it from our systems it shows an error saying number stored as text. I need the cells to be stored as General format. So if click in the cell and press enter the error goes away and vlook up recognises the number and my vlook ups now work for different data.

My question is since i have 60000 unique cells which i need to press F2, then enter for the format to fix itself, how do i do this on mass. If i highlight the full column and change format to General it simply doesnt work and the errors remain, so the only way i know is to click in each cell or press f2 then enter, but this only works cell by cell

any help apprecited

 

[KRice]

Try this on a copy of your worksheet (in case it doesn't work). Type a 0 somewhere out of the way and copy it to your clipboard. Then select a range of ID's and choose Paste Special...then select the Add option to add the 0 on the clipboard to the "numbers". This coerces Excel to convert the text to numbers. The issue is that some of your ID's appear to begin with a leading 0, and this conversion will drop the leading zeroes.

 

[SunnyAlv]

Coba ini

1. pilih semua data
2. klik tanda seru
3. klik " Konversi Ke Angka "

 

[Peter_SSs]

Coba ini

1. pilih semua data
2. klik tanda seru
3. klik " Konversi Ke Angka "

As mentioned to you previously, this forum specifies posting in English only.

 

[SunnyAlv]

As mentioned to you previously, this forum specifies posting in English only.

I used translate and I copied the translated sentence incorrectly, I really apologize, as did the previous thread

 

[Peter_SSs]

I used translate and I copied the translated sentence incorrectly, I really apologize, as did the previous thread

So in future after you post, immediately check it for language and edit if needed.