Hi,
Can anyone help. I am using the WEEKNUM fuction to enter the week numberin a
cell, I would like to add the numbers 1134 after the week number but in the
same cell. Is this possible,

Thanks

Hi,

try this

=WEEKNUM(A1)&1134

Mike

"Mike B" wrote:

Hi,
Can anyone help. I am using the WEEKNUM fuction to enter the week numberin a
cell, I would like to add the numbers 1134 after the week number but in the
same cell. Is this possible,

Thanks

What do you mean by "add the numbers 1134 *after* the week number"? Do you
mean if the week number was 25, you want the formula to return 251134 or
1159? Also, show us your formula so we can show you want to do to it to get
your desired result.

--
Rick (MVP - Excel)


"Mike B" wrote in message
...
Hi,
Can anyone help. I am using the WEEKNUM fuction to enter the week numberin
a
cell, I would like to add the numbers 1134 after the week number but in
the
same cell. Is this possible,

Thanks

Thanks, it worked a treat.


"Mike H" wrote:

Hi,

try this

=WEEKNUM(A1)&1134

Mike

"Mike B" wrote:

Hi,
Can anyone help. I am using the WEEKNUM fuction to enter the week numberin a
cell, I would like to add the numbers 1134 after the week number but in the
same cell. Is this possible,

Thanks

hi,
I wanted the numbers to follow the week number ie 251135, however the
quuestion has been answered, thanks for your offer of hlep anyway

Mike B

"Rick Rothstein" wrote:

What do you mean by "add the numbers 1134 *after* the week number"? Do you
mean if the week number was 25, you want the formula to return 251134 or
1159? Also, show us your formula so we can show you want to do to it to get
your desired result.

--
Rick (MVP - Excel)


"Mike B" wrote in message
...
Hi,
Can anyone help. I am using the WEEKNUM fuction to enter the week numberin
a
cell, I would like to add the numbers 1134 after the week number but in
the
same cell. Is this possible,

Thanks