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...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top