Merge multiple cell

March 24, 2009 at 09:29:05
Specs: Windows XP
Hi I have been trying to merge multiple cells of date and time using A&" "&B but got strange result see below
(38803 0.346643518518519) (27 March 2006) (08:19:10)
I was wondering if anybody help me ASAP
Thanks

See More: Merge multiple cell

Report •


#1
March 24, 2009 at 15:53:08
You have to format the cell with some type of DATE & TIME format.

On the tool bar, Format, Cells, Date,
scroll down until you find the format
for Date & Time

MIKE


Report •

#2
March 25, 2009 at 03:12:28
Hi Mike,
I am still getting same results.

Report •

#3
March 25, 2009 at 04:23:04
Can't use the & use + instead

=A1+B1

Make sure the cell if formatted as mm/dd/yy hh:mm:ss

MIKE


Report •

Related Solutions


Ask Question