Page 2 of 2 FirstFirst 12
Results 17 to 19 of 19

Thread: Calling all Excel wizards

  1. #17
    Senior Member Tumble's Avatar
    Join Date
    Jul 2003
    Location
    Right in the Pickle Barrel
    Posts
    7,217
    Thanks
    271
    Thanked
    315 times in 217 posts

    Re: Calling all Excel wizards

    Thanks for all the help & suggestions I believe I have got it gripped now, and in the layout I've been using Can always count on Hexus for an assist!

    Quote Originally Posted by The Quentos
    "My udder is growing. Quick pass me the parsely sauce." Said Oliver.

  2. Received thanks from:

    ik9000 (16-05-2017),mycarsavw (25-05-2017)

  3. #18
    RIP Peterb ik9000's Avatar
    Join Date
    Nov 2009
    Posts
    7,701
    Thanks
    1,839
    Thanked
    1,434 times in 1,057 posts
    • ik9000's system
      • Motherboard:
      • Asus P7H55-M/USB3
      • CPU:
      • i7-870, Prolimatech Megahalems, 2x Akasa Apache 120mm
      • Memory:
      • 4x4GB Corsair Vengeance 2133 11-11-11-27
      • Storage:
      • 2x256GB Samsung 840-Pro, 1TB Seagate 7200.12, 1TB Seagate ES.2
      • Graphics card(s):
      • Gigabyte GTX 460 1GB SuperOverClocked
      • PSU:
      • NZXT Hale 90 750w
      • Case:
      • BitFenix Survivor + Bitfenix spectre LED fans, LG BluRay R/W optical drive
      • Operating System:
      • Windows 7 Professional
      • Monitor(s):
      • Dell U2414h, U2311h 1920x1080
      • Internet:
      • 200Mb/s Fibre and 4G wifi

    Re: Calling all Excel wizards

    Quote Originally Posted by MalcolmMurdoch View Post
    why when I enter the number 1.0615 it turns into a date?
    because it thinks you're a prune?

  4. #19
    Senior Member Tumble's Avatar
    Join Date
    Jul 2003
    Location
    Right in the Pickle Barrel
    Posts
    7,217
    Thanks
    271
    Thanked
    315 times in 217 posts

    Re: Calling all Excel wizards

    Quote Originally Posted by MalcolmMurdoch View Post
    why when I enter the number 1.0615 it turns into a date?
    Quote Originally Posted by ik9000 View Post
    because it thinks you're a prune?
    HAHAH.. no, really I know this one! That'll be your basic cell formatting - you need to change it to either "number" or "general"

    Quote Originally Posted by The Quentos
    "My udder is growing. Quick pass me the parsely sauce." Said Oliver.

Page 2 of 2 FirstFirst 12

Thread Information

Users Browsing this Thread

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

Posting Permissions

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