04 November, 2010

convert excel tesxt to numbers

Hi,

Just wanted to let you know that I found a way to convert numbers that apear as text back to numbers.
If you have a formula that retrieve a number with a text function, when I try to do a vlookup on this it would not work.
Just multiply it by 1 and you will be OK.

No comments:

Post a Comment