concatenate

A

April

i am concatenating several cells. one of the cells has a date - its format
in the cell that i am concatenating is 11/30/03. however, when i concatenate
the cell its format becomes the numerical equivalent of the date 37955. how
can i get around this?

thank you in advance for your help.
 
L

Luke M

you can use the text function like this:
=A2&TEXT(A3,"mm/dd/yy")

Which concatenates A2 with the date in a3 (formatted as in your example)
 
A

april

i sent a thank you for the help yesterday (all the solutions worked).
however, my email seemed to be stalled so i don't know if the thank you was
sent or not. if not, a big thanks again.
 
P

Per Jessen

Hi April

Thanks for your reply, I am glad to help.

Your post was sent yesterday.

/Per
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changes Required In Macro Code 2
Concatenating & Formatting 6
VBA concatenate ranges into a new document 0
Concatenate, currency & sum formula 2
Calculate days, months and weeks difrence 0
*Issue* Concatenate dates in a large range of cells in a row. 5
Excel 2003 with Reference error cause me a headache 0
Generating a cell reference within a formula 5

Top