+ Reply to Thread
Results 1 to 3 of 3

Format of data import from a database

  1. #1
    John Conklin
    Guest

    Format of data import from a database

    I have a spreadsheet that has data imported from SQL Server or even MS
    Access that has dollar amount fields. The field is coming over as a text
    field and even if I format the cells as currency it won't apply the
    formatting until I actually double click in the cell and press enter.

    Is there a way to fix this for the entire spreadsheet so I don't have to
    click in each cell to force the formatting to work? This spreadsheet as
    over 1500 rows of data. I get this every time I export data from either SQL
    Server 2000 or Microsoft Access Database.

    Any help or information is greatly appreciated.

    Thanks,
    ~John



  2. #2
    Gord Dibben
    Guest

    Re: Format of data import from a database

    John

    This usually works........

    Format an empty cell to General or Number.

    Copy that cell.

    Select all other data cells and Paste Special>Add>OK>Esc.


    Gord Dibben Excel MVP

    On Thu, 10 Feb 2005 09:55:04 -0700, "John Conklin"
    <john.conklin@discussions.microsoft.com> wrote:

    >I have a spreadsheet that has data imported from SQL Server or even MS
    >Access that has dollar amount fields. The field is coming over as a text
    >field and even if I format the cells as currency it won't apply the
    >formatting until I actually double click in the cell and press enter.
    >
    >Is there a way to fix this for the entire spreadsheet so I don't have to
    >click in each cell to force the formatting to work? This spreadsheet as
    >over 1500 rows of data. I get this every time I export data from either SQL
    >Server 2000 or Microsoft Access Database.
    >
    >Any help or information is greatly appreciated.
    >
    >Thanks,
    >~John
    >



  3. #3
    John Conklin
    Guest

    Re: Format of data import from a database

    You are wonderful!!!

    That does exactly what I needed.

    Thank you so much for your help.

    ~John
    "Gord Dibben" <gorddibbATshawDOTca> wrote in message
    news:837n011ftuoc2f41hrarb2840det2miigr@4ax.com...
    > John
    >
    > This usually works........
    >
    > Format an empty cell to General or Number.
    >
    > Copy that cell.
    >
    > Select all other data cells and Paste Special>Add>OK>Esc.
    >
    >
    > Gord Dibben Excel MVP
    >
    > On Thu, 10 Feb 2005 09:55:04 -0700, "John Conklin"
    > <john.conklin@discussions.microsoft.com> wrote:
    >
    > >I have a spreadsheet that has data imported from SQL Server or even MS
    > >Access that has dollar amount fields. The field is coming over as a text
    > >field and even if I format the cells as currency it won't apply the
    > >formatting until I actually double click in the cell and press enter.
    > >
    > >Is there a way to fix this for the entire spreadsheet so I don't have to
    > >click in each cell to force the formatting to work? This spreadsheet as
    > >over 1500 rows of data. I get this every time I export data from either

    SQL
    > >Server 2000 or Microsoft Access Database.
    > >
    > >Any help or information is greatly appreciated.
    > >
    > >Thanks,
    > >~John
    > >

    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1