Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2002
    Location
    NJ
    Posts
    139

    Unanswered: Excel cell value deformed

    xp
    excel 2k

    Hi,

    I have a spreadsheet with certain alphanumeric and sometimes numeric values only. I have formated the column as text, but sometimes, the values are shrank in this way 1.3209E+11. My ? is how can I get rid of this and replace it with its true value 132090115901? If there is a way to do this without writing some code, then great. Please let me know. otherwise maybe the code bellow could be the basis.

    Thanks for your anticipated answers.

    Alex

    Code:
    Dim i As Integer
    Dim lastrow As Long
    lastrow = ActiveSheet.UsedRange.Rows.Count
    
    For i = 1 To lastrow
    
        Range("G" & i).Select
       ????????????????????
        
    Next i

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Typically that means the column is too narrow. Adjust column width and see what happens.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Sep 2002
    Location
    NJ
    Posts
    139

    Excel Cell value deformed

    resizing the column does not change a thing.

  4. #4
    Join Date
    Oct 2003
    Posts
    1,091
    Then try to format the cell as Number rather than text.

    However, if you want all to be text (except when number) then code is the way to go. Perhaps check to see whether it is numeric or text, then change formatting appropriately.
    Last edited by shades; 08-03-06 at 14:00.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  5. #5
    Join Date
    Mar 2006
    Posts
    163
    Alex

    How is the data being put on the worksheet?

    Have you tried formatting as Text before the data is put on the worksheet?

Posting Permissions

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