Hi,
I have just come across a problem. I extracted from a database fields which have numbers in it but when they are received in Excel they are actually text. Now I am faced with the problem of converting them to a number field. I wanted to use the vlookup function and wanted to compare two numbers but because one is a text field and the other a number it returns #N/A.
Thanks for your help
Andonny
I have just come across a problem. I extracted from a database fields which have numbers in it but when they are received in Excel they are actually text. Now I am faced with the problem of converting them to a number field. I wanted to use the vlookup function and wanted to compare two numbers but because one is a text field and the other a number it returns #N/A.
Thanks for your help
Andonny