Unfortunatly I do not have Excell, however I am unsure whether it would help with the dilema I have created...
Using the Works Spreadsheet I am unable to turn a column of numbers into a colunm of "text", all I need to do is have it recognized as text so as I can create a formula to put more text characters in front of the number (importing vendors price lists to the POS, however many of them have the same codes and I need to separate them).
To explain further... an entry needs a delimiter (") at the front of it to make the software recognize it as text so I can use the formula "=MPML&B2", with B2 (e.g 100022) being a number the result is "ERR", if B2 is recognized as text the result is MPML100022, just what I want!
Any ideas would be appreciatted as I have thousands of lines to do...
Using the Works Spreadsheet I am unable to turn a column of numbers into a colunm of "text", all I need to do is have it recognized as text so as I can create a formula to put more text characters in front of the number (importing vendors price lists to the POS, however many of them have the same codes and I need to separate them).
To explain further... an entry needs a delimiter (") at the front of it to make the software recognize it as text so I can use the formula "=MPML&B2", with B2 (e.g 100022) being a number the result is "ERR", if B2 is recognized as text the result is MPML100022, just what I want!
Any ideas would be appreciatted as I have thousands of lines to do...
