text and date format in a cell

N

Nicawette

Hi all,

is it possible to format an excel cell with a text and a date in the
same cell ?

eg :

In A1 I've a text cell : "360 :"
In A2 I've a date formated in ddmmyy
In A3 I've a text cell :"zzzzzzz"

In A4 I would like to concatenate all the cells but I've the following
result : "360:38895zzzzzzz" instead of "360:ddmmyyzzzzzzz" where 38895
is the excel date.

Thank you

Nic
 

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

Combining Text From Cells 3
date & month 6
Concatenate 1
Excel Typed text appears in wrong cell 0
Conditional Format of Text 1
test for click in cell 2
How To Have A Cell Be Blank If... 2
Change Cell colour on click 5

Top