Spreadsheet woe...

Lance E

SGF, Supreme Grumble Framer
Forum Donor
Joined
Oct 31, 1999
Posts
3,869
From
Hamilton, New Zealand
Business
Imageland
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...
 

David Waldmann

Herder of cats
Forum Donor
Vendor
Featured Vendor Forum Sponsor
Joined
Feb 6, 2002
Posts
8,402
From
Chester, Vermont USA
Business
Vermont Hardwoods
With Quattro Pro here's what works:

If text is in B1 and number is in B2,

Use the formula: +B1&@STRING(B2,0)
Convert to Value

HTH
 

Lance E

SGF, Supreme Grumble Framer
Forum Donor
Thread starter
Joined
Oct 31, 1999
Posts
3,869
From
Hamilton, New Zealand
Business
Imageland
Thank-you David, a small variation on that works perfectly!
(+A30&STRING(D30,0))
 
Top