Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Dec 2007
    Location
    Sacramento, California, USA
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts

    convert a number to a date

    I have cells with years formatted as a number. I need to convert that number into a corresponding date.

    i.e. 2005 needs to be 01/01/2005

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    find/replace

    2005
    01/01/2005

    Will work

    Steve

  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Levin, Manawatu-Wanganui, New Zealand
    Posts
    324
    Thanks
    9
    Thanked 28 Times in 26 Posts
    Hi
    You might try and use the date function.

    In an adjacent col

    =date(cellRefContaining2005,1,1)

    Format the result as date.

    Cheers
    G

Posting Permissions

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