Convert input data
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Convert input data

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

    Default

     
    Hi guys playing with :

    If i input 21 say as today is 21st Feb 2002 i need to convert to Correct 21st Feb 2002

    All i will input is 21??? any ideas guys rather than have 21 in one column and next column converts.

    Cheers guys

    Rdgs
    =========
    Jack



  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,579
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Jack
    Custom format cells #"st Feb 2002"
    Is that what you mean?
    Derek

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Or use:

    DateValue(Year(Date),Month(Date),MyInput+0)

    Regards,

    Juan Pablo González
    http://www.juanpg.com

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

    Default

    Cheers guys...

    big thanks

    Rgds
    ===========
    Jack

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Location
    Boston, Mass
    Posts
    182
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Jack,
    You could try...
    =DAY(C8)&IF(INT(MOD(DAY(C8),100)/10)=1,"th",IF(MOD(DAY(C8),10)=1,"st",IF(MOD(DAY(C8),10)=2,"nd",IF(MOD(DAY(C8),10)=3,"rd","th"))))&" "&TEXT(C8,"mmm yyyy")
    where c8 houses a date but the result becomes text.

    HTH,
    Drew
    FYI the above comes from J. Walkenbach. Someday I'll get there!

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