How to convert number to text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
Need your professional guys' help.
How can I conver specific inot specific text in excel table, not only one
data.
I had used "TEXT" function, EX: =TEXT(2,"good"). It was work but only
applied on one data input.
My Question is:
1) How can I apply server "TEXT" functions into one Excel sheet at one click?

Thanks in advance.
 
Hi,
Thanks for your suggestion.
Since there are many types of data and may cost me much time on edit-replace
for every type.
 
Hi
but do you have a logic for replacing numbers with text or a lookup
table?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Which is the best MBOX Converter Tool different formats conversion? 4
Convert Text to Number 1
Convert Numbers to Text 4
Text to Rows 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How to convert text "JAN" into number 1? 9
Converting number to text 2
Converting Number to text 1

Back
Top