Formatting Dates - Page 2
Formatting Dates
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: Formatting Dates

  1. #11
    Guest

    Default

     
    Thanks Richard.

    Hadn't thought about that, I think that that is why it is causing problems though. Thanks mate.

    I'm from the Gold Coast by the way. Good to see some Aussies around in here!

    Seeya


  2. #12
    Guest

    Default

    Ok. I have been able to get the data like this through text-columns:

    a b c
    1 24 1984
    1 25 1984
    1 26 1984
    1 27 1984
    1 30 1984
    1 31 1984
    2 1 1984
    2 2 1984
    2 3 1984
    2 6 1984
    2 7 1984
    2 8 1984

    Can I now put this back together in the format that I want? So can i recognise column A as month, B as day and C as year and 'mash' them back together?

    Thanks again guys. Sorry for prolonging this!

  3. #13
    Board Regular RichardS's Avatar
    Join Date
    Feb 2002
    Location
    Victoria, Australia
    Posts
    761
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    =(A1&"/"&B1&"/"&C1)*1 and format how you want it, then just copy down.
    Richard

  4. #14
    Guest

    Default

      
    You beauty!

    Got it. Thanks a lot for all your help guys!


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
  •  

 

 
DMCA.com