Converting Numbers in a Text Field To Text RRS feed

  • Question

  • Hello:

    When I import a column of numbers from another source into a "General" Excel column and then convert the entire column to text (Select Column, Format as Text), the usual warning icon in the upper left of the cell that says you have a number in a text field doesn't appear.

    I have always had to write a VBA procedure to copy the cell value into a numeric variable (i.e. Dim txtNumber as Number) and then copy it back:

    txtNumber = Cells(i,"A")

    Cells(i, "A") = txtNumber

    This will present the usual warning icon in the cell.

    But... is there a way to accomplish the same thing using a formula where the warning icon appears?

    See examples.



    Rich Locus, Logicwurks, LLC

    Thursday, January 2, 2020 7:21 PM

All replies

  • To:  Rich
    re:  warning errors

    Why not just remove the checkmark from "enable background error checking"
    remove the checkmark from "Numbers formatted as text or preceded by an apostrophe"
    -found in-
    File | Options | Formulas | Error checking...

    Excel programs (now free) at MediaFire...
    The Custom_Functions add-in has 20+ new Excel functions including the vLookUpAny function
    (or try the Switches, Concats, Mid_R, NumsValue functions)

    Friday, January 3, 2020 1:43 AM