dates and numbers
 

I've got to put 2 numbers together. they are in different cells. on is a date
vhile the other is a value e.g.

C4 has 011 and D4 has a date value of 0702 (february 2007)

when I use =D4&C4, i'd like to have 0702011, but I get 3911511

how can I have 0702011

dates and numbers
 

=TEXT(D4,"yymm") & C4

--
Gary's Student
gsnu200707


"be_mcwayne" wrote:

I've got to put 2 numbers together. they are in different cells. on is a date
vhile the other is a value e.g.

C4 has 011 and D4 has a date value of 0702 (february 2007)

when I use =D4&C4, i'd like to have 0702011, but I get 3911511

how can I have 0702011

dates and numbers
 

I think you'll need a slight modification from GS's to get the number
in the right format:

=TEXT(D4,"yymm") & TEXT(C4,"000")

Hope this helps!

Richard


On 22 Feb, 10:06, Gary''s Student
wrote:
=TEXT(D4,"yymm") & C4

--
Gary's Student
gsnu200707



"be_mcwayne" wrote:
I've got to put 2 numbers together. they are in different cells. on is a date
vhile the other is a value e.g.

C4 has 011 and D4 has a date value of 0702 (february 2007)

when I use =D4&C4, i'd like to have 0702011, but I get 3911511

how can I have 0702011- Hide quoted text -

- Show quoted text -

dates and numbers
 

Thank you for the correction.
--
Gary's Student
gsnu200707


"RichardSchollar" wrote:

I think you'll need a slight modification from GS's to get the number
in the right format:

=TEXT(D4,"yymm") & TEXT(C4,"000")

Hope this helps!

Richard


On 22 Feb, 10:06, Gary''s Student
wrote:
=TEXT(D4,"yymm") & C4

--
Gary's Student
gsnu200707



"be_mcwayne" wrote:
I've got to put 2 numbers together. they are in different cells. on is a date
vhile the other is a value e.g.

C4 has 011 and D4 has a date value of 0702 (february 2007)

when I use =D4&C4, i'd like to have 0702011, but I get 3911511

how can I have 0702011- Hide quoted text -

- Show quoted text -