Forum Home
Press F1
 
Thread ID: 23970 2002-08-31 01:04:00 MSWorks Spreadsheet kara_19 (1689) Press F1
Post ID Timestamp Content User
75179 2002-08-31 01:04:00 I want to convert a set of numbers to text. This is easily done with QPRO but, search as I have, I cannot find this option in MSWorks spreadsheet. Does anybody know the solution? kara_19 (1689)
75180 2002-08-31 01:57:00 For a single cell, you can place an apostrophe ( ' ) as the first character, which forces that cell to display as text (the cell contents become left-aligned for text vs. right-aligned for numberical).

If you wanted to do a whole row or column in one hit, well .... ummm .....
antmannz (28)
75181 2002-08-31 05:36:00 Try highlighting the column of numbers then go to Format>Number and under the Number tab choose the Text option down the bottom.

That should work.
Susan B (19)
1