Excel Convert Numbers into Text. Error #N/A in VLookup, Type Convert 13 in Macros

he following example shows how to convert numbers to text in Microsoft Excel.
The problem is that SAP used to output numbers such as personnel numbers or accounts in Excel as text. You could see it by the fact that the numbers were displayed left-aligned in Excel.
Since 2019, however, SAP has been issuing Excel exports as figures. These have since been displayed on the right."
If original text searches such as SVerweis, WVerweis, Comparison, and other formulas had searched for a position, then the result is #NV.
In Excel vba macros comes the error message error code 13 type conversion error

Concerns:
Formula Search Error =SVERWEIS("1"; B4:B9;1)
Error: Code 13 Type Conversion as Error

Solutions:
Solution 1:
you can write a macro that goes through each cell and with the formula : text (cell address;" ") it emanates
Solution 2:
You can select the area, then menu-Data-Text in columns -in step 3 set the data format to Type=Text and click finished