formating numbers to text in columns
Try this:
Select your column of numbers
<data<text-to-columns
Check: Fixed Width.....Click [Next] twice
Set the column format to: Text
Click the [Finish] button
That should convert the numbers to text.
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"TimR" wrote:
How can you convert a column of formatted numbers to a column of text. I
can go into format/cells/text..but when I do I do not get the little
triangle in the cells upper left hand corner indicating a number formatted
as text.
For whatever reason...my app that uses this info will not work right unless
that little triangle is there in Excel.
Is there a way to change a whole column and get the triangle marker there in
one operations
Excel 2003
Thanks, Tim
|