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


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


    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)
    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!