number to text

  1. M

    Lookup Numbers & Result in Corresponding Text

    Hi All, Is it possible to lookup a string of numbers in any cell from other workbook and result in the corresponding text (Excel 2007) Thank you in advance. For example: <tbody> Lookup Cell Result 1, 2, 4, 12, 14 Relay burnt, Capacitor Burnt, Suction Joint Gas leak, Overload burnt...
  2. I

    Vlookup, Hlookup across tabs

    I trying to develop a formula to return a variance amount from using a vlookup, hlookup, match or index. The is the tab in which the formula would be entered. <colgroup><col><col><col><col><col><col><col><col><col span="6"></colgroup><tbody> Date Name Variance 02/27/15 Mike (99.95)...
  3. KG Old Wolf

    VBA - numeric to text

    This must be simple but it eludes me. I have a set of values 0 to 99 that I need to append as a two character string to an existing string. I can go through an "if" routine that checks and then functions but it seems like "too much cure for too little sickness". Isn't there some easy one...
  4. A

    Converting a number to text in the format "0## ### ####

    In the old versons of excell I was able to format a number such as a cell number to start with 0 and then break the number down to have a space after the third and sixth digit via the custom text field in format number using 0## ### ####. Simelarly I could achieve the same effect with...
  5. caritx

    Number stored as text

    I have a column that has both numbers stored as text and text. I need the numbers to be stored as number. I have tried to (a1*1) but then on the text I get #value. Trim didn't help either. This is really frustrating because my vlookup won't accept number stored as text. Any help you can...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top