none
Year turns to value RRS feed

  • Question

  • Hi,

    I want to use =(C6)&""&"-"&""&(C7) in a cell, where C6 is 1995 and C7 is 1996,  for year reference. It does not allow me to show 1995-1996 but 34790-34820 instead. Can I do it ? or not ?

    Please help me.

    dockhem


    • Edited by dockhem2 Tuesday, November 11, 2014 8:45 AM
    Tuesday, November 11, 2014 8:44 AM

Answers

  • If they are just numbers try

    =C6&"-"&C7

    but if they are dates then try

    =YEAR(C6)&"-"&YEAR(C7)

    • Marked as answer by dockhem2 Tuesday, November 11, 2014 10:39 AM
    Tuesday, November 11, 2014 9:40 AM

All replies