Hi all,

Firstly - my apologies for the now triple post. I had problems posting
(zero byte reply) so while the initial two show as threads - there is
not content in the message. I would appreciate it if a mod could clear
up my mess :)

Hoping someone can help with what may be a trivial problem - however it
is causing me enough pain and suffering to post here.

In A1 I have a date, format ddmmyy. In B1 I have an ID number...any
four digit number.

In A3 I want to join the two together....so I use -

=A1&"-"&B1

Then the date is referred to as a serial number.....so I get in A3

32543-1234

instead of 230105-1234.

I have tried to get around this in A2 with -

=DAY(A1)+MONTH(A1)+YEAR(A1)

This works when I reference it with my formula in A3 - but the date
format cannot be formatted. I tried to split the formula in A2 over
three cells, and format them individually - but only the DAY component
could be successfully formatted to dd.

So if anyone could offer any advice as to how I may be able to
reference a date as text (ie what you see, not the serial number) - I
would be really greatful!

Thanks

rob :)


--
systemx
------------------------------------------------------------------------
systemx's Profile: http://www.excelforum.com/member.php...o&userid=29254
View this thread: http://www.excelforum.com/showthread...hreadid=504705

Try this formula

=TEXT(A1,"ddmmyy")&"-"&B1


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=504705

Hi,

Try

=TEXT(A1,"DD/MM/YY")&"-"&B1

Govind.

systemx wrote:
Hi all,

Firstly - my apologies for the now triple post. I had problems posting
(zero byte reply) so while the initial two show as threads - there is
not content in the message. I would appreciate it if a mod could clear
up my mess :)

Hoping someone can help with what may be a trivial problem - however it
is causing me enough pain and suffering to post here.

In A1 I have a date, format ddmmyy. In B1 I have an ID number...any
four digit number.

In A3 I want to join the two together....so I use -

=A1&"-"&B1

Then the date is referred to as a serial number.....so I get in A3

32543-1234

instead of 230105-1234.

I have tried to get around this in A2 with -

=DAY(A1)+MONTH(A1)+YEAR(A1)

This works when I reference it with my formula in A3 - but the date
format cannot be formatted. I tried to split the formula in A2 over
three cells, and format them individually - but only the DAY component
could be successfully formatted to dd.

So if anyone could offer any advice as to how I may be able to
reference a date as text (ie what you see, not the serial number) - I
would be really greatful!

Thanks

rob :)

Thank you both.

Worked like a charm :)


--
systemx
------------------------------------------------------------------------
systemx's Profile: http://www.excelforum.com/member.php...o&userid=29254
View this thread: http://www.excelforum.com/showthread...hreadid=504705