Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Formatting cells after importing from Access

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I exported a query from MS Access into MS Excel and now I can not format the numbers. The worksheet is not protected.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Most likely your numbers were imported as text representations of numbers (e.g., "10", "3", etc.). Number formatting won't work with text. If you can't fix your query to produce numbers you can select your values, and choose the Data | Text to Columns... menu command to convert them. If your query is producing numbers then it may be that the range housing these numbers was initially formatted as Text. Now that you've changed the formatting the process above will respect the new format and convert the values. Happy computing!!

    [ This Message was edited by: Mark W. on 2002-02-20 15:48 ]

  3. #3
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You can also try placing a 1 in any cell (even on another worksheet). Copy that cell. Select the *bad* number cells. Hit Edit-Paste special-Multiply. This multiplies the number by 1, which forces Excel to see those values as numbers.


  4. #4
    Guest

    Default

    Maria,

    Use "Dreamboat's" suggestion, but do it in Access. In other words, modify your query to perform the "conversion" when you run your query.

    For example, if the offending field is called "Quantity" then modify your query like this:

    Qty: Quantity * 1

    In this way you don't have to constantly do this conversion in Excel.


    enjoy

    Bariloche

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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