Changing format in combined cell

[Lady Layla]

I am combining data in a seperate cell. In Cell A1 I have a number (ie 2) and
in Cell A2 I have a date (ie 08/31/04).

What I would like to do is in Cell A3 combine the 2 so that I come up with
2-0804

I have =A1&"-"&A2 but is it possible to change the format of the date I pull
from A2 and make it MMYY vs MM/DD/YY/

Thanks in advance for the assistance

 

[Ron de Bruin]

Try this Lady

=A1& "-" & TEXT(A2,"mmyy")

 

[Lady Layla]

Perfect! Thank you!!!

: Try this Lady
:
: =A1& "-" & TEXT(A2,"mmyy")
:
:
: --
: Regards Ron de Bruin
: http://www.rondebruin.nl
:
:
: >I am combining data in a seperate cell. In Cell A1 I have a number (ie 2)
and
: > in Cell A2 I have a date (ie 08/31/04).
: >
: > What I would like to do is in Cell A3 combine the 2 so that I come up with
: > 2-0804
: >
: > I have =A1&"-"&A2 but is it possible to change the format of the date I
pull
: > from A2 and make it MMYY vs MM/DD/YY/
: >
: > Thanks in advance for the assistance
: >
: >
: >
: >
: >
:
:

 

[Guest]

hi,
i think you are going to have problems because of the date.
dates are 5 digit numbers. formating just changes the
looks. in your example if you concatinated 2 and 8/31/04
you would end up with 2-38230 no matter how the date was
formated.