Concatenate

S

Sena

Hi, need some help on formatting a cell with concatenate function. Pls see
example below ;

cell A1 = 9 Sep 2007 ( date formatted )
cell A2 = Margin (text)

In cell A3, I need to combine cells A1 & A2 and get " Margin 9 Sep 2007".

When I used concatenate formulae in cell A3, date doesn't come but a value
39334 appears eventhough cell A3 is date formatted. Pls advise how to get the
date format on cell A3.

Thanks
 

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


Top