Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    386
    Thanks
    3
    Thanked 0 Times in 0 Posts
    I started a new worksheet and populated it. Columns C & D did not record the input as numbers but the columns G - I did. Why does this happen? What can I do to make the non-numeric Columns C & D numeric? Is there a way that I could see the format of the cell?

    Thank you
    Attached Files Attached Files

  2. #2
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Are you opening from a template or by clicking on the New File button or file New?

    Some of the cell in the C column have been formatted as "Accounting" but still show left adjustment because the cells have not been editted since the format change.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Some of these cells are formatted as Text.

    The easiest way to convert them to numbers is to select the block of cells and to select Convert to Number from the dropdown in the Smart Tag.

    Or:
    - Select columns C and D.
    - Select Format | Cells...
    - In the Number tab, select General and click OK.
    - Press Alt+F11 to activate the Visual Basic Editor.
    - Press Ctrl+G to activate the Immediate window.
    - Type

    selection.value = selection.value

    - Press Enter.
    - Switch back to Excel.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •