Tom's Guide | Tom's Hardware | Tom's Games

Computing.Net > Forums > Database > Merge multiple cell

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Merge multiple cell

Reply to Message Icon

Name: rudra
Date: March 24, 2009 at 09:29:05 Pacific
OS: Windows XP
Subcategory: General
Comment:

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



Sponsored Link
Ads by Google

Response Number 1
Name: Mike (by mmcconaghy)
Date: March 24, 2009 at 15:53:08 Pacific
Reply:

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


0

Response Number 2
Name: rudra
Date: March 25, 2009 at 03:12:28 Pacific
Reply:

Hi Mike,
I am still getting same results.


0

Response Number 3
Name: Mike (by mmcconaghy)
Date: March 25, 2009 at 04:23:04 Pacific
Reply:

Can't use the & use + instead

=A1+B1

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

MIKE


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Database Forum Home


Sponsored links
Ads by Google


Results for: Merge multiple cell
improper format merge www.computing.net/answers/dbase/improper-format-merge/435.html

ACCESS Record Merge www.computing.net/answers/dbase/access-record-merge/293.html

Access 2003 - Data going missing www.computing.net/answers/dbase/access-2003-data-going-missing/190.html