Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Problem with query

  1. #1
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a query set up on a master data Excel sheet to extract various columns and put the details on to a 'Timesheet' (again Excel). My problem is that the project nos are not all being pulled through. Some of them are a mixture of text and nos (eg XXX123) while others (the ones not being pulled over) are just five figure nos. Does anyone know a way around this? Thanks in advance for any help.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    OK, sorted it (I think ). Use text-columns on the existing data, format the column as text for any additional data added afterwards. Jeesh.

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Mudface

    sorry mate did not see this else could have advised worth remember t to c cover many issues in downloads.

    watch them arrows lines can be off the mark thou:


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

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
  •