Convert Number to Text

babyhime4

New Member
Joined
Oct 19, 2007
Messages
9
How can I format a column of numbers as text other than:

1. Format Cells... select "Text" on the number tab
2. Create a column with the apostrophe, and use CONCATENATE function
3. Use TEXT function or any other type of function
4. Macros


Is there a fast and simple way to do this if I need to do it on a daily basis?
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

VoG

Legend
Joined
Jun 19, 2002
Messages
63,651
Select the column, Data > Text to Columns, click Next twice, tick Text then click Finish.
 

babyhime4

New Member
Joined
Oct 19, 2007
Messages
9
you're awesome! can i give you a big virtual hug? Too late, i just did!


Thanks!
 

Watch MrExcel Video

Forum statistics

Threads
1,099,699
Messages
5,470,241
Members
406,686
Latest member
BNR_ 1980

This Week's Hot Topics

Top