Importing: Number format is wrong

    Hi all:


    I am new to these forums, so please help.


    I have created an NFL season database using FileMaker. Basically, I am copy/pasting info from the nfl.com website into Excel so that i can export it to FileMaker.


    Here is my problem: when I paste info from the site some cells will show the incorrect format.


    For example, one column is Division Record, which would be like 1-2. But some cells show "Jan 1 - Feb 1" or something like that. If I format the cells in general, number or text format, it will correct the problem on some of the cells, but others just turn into a numerical value.


    If you can help, please do. I have attached the resulting SS to this post


    Thanks in advance for any help.


    Ken

    When pasting into Excel Right click and Choose Paste Special and see what you get.


    You may be able to Paste Values or if excel doesn't recognise the data as a table you might be able to paste as Text.


    HTH

    There are three types of people in this world.
    Those who can count and those who can't.

    I have the same problem importing from CSV sheets and use a conversion macro similar to this.
    This macro converts the cells in place but can be modified to place into an adjacent column.


    Sub DateCon()
    For x = 1 To 100
    If IsDate(Cells(x, 1)) Then
    Cells(x, 1).Value = "'" & Month(Cells(x, 1).Value) & "-" & Day(Cells(x, 1).Value)
    Else
    Cells(x, 1).Value = Cells(x, 1).Value
    End If
    Cells(x, 1).NumberFormat = "@"
    Next x
    End Sub

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login