Posted to microsoft.public.excel.misc

orquidea

external usenet poster

Posts: 132

Date Formating

Hi

I merge 2 date and time cells with the formula = A5 &"" & B5 where A5 is
9/12/2007 and B5 is 16:00. The result I get is 393370.666666666666667. I
tried to format as mm/dd/yyyy hh:mm or any other date and time format none
worked.

Does anyone know how can I get the format I want.

Thanks in advance for your help.

Orquidea

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date Formating	Mel	Excel Worksheet Functions	5	February 22nd 07 04:13 PM
Date formating	Hawksby	Excel Discussion (Misc queries)	2	December 14th 06 06:33 PM
Date formating	chad	Excel Worksheet Functions	3	October 21st 06 03:31 PM
formating a date field	Stephen	Excel Discussion (Misc queries)	3	January 25th 06 08:33 PM
Conditional formating w/ Date	Steven Stadelhofer	Excel Worksheet Functions	1	February 3rd 05 05:29 PM

All times are GMT +1. The time now is 10:15 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us