Hi
U can use below mentioned formula
TEXT(A1, "DD/mm/ H:MM:SS AM/PM ")& B1
Regards
Krupesh
On Tue, May 12, 2009 at 1:27 PM, wrote:
>
> Hello,
>
> I have a problem in displaying AM or PM, when i try to concatenate to
> cells. Below is the reference -
>
> Column A Column B
Hey Rakesh,
Thanks It Works,
Thanks
Regards,
Jitendra
On Wed, May 13, 2009 at 7:38 PM, Rakesh Sharma wrote:
>
> Hi
>
> You can try this.
>
> Column A Column B Column C
> 5/13/2009 19:33 ABC =CONCATENATE(TEXT(A1,"m/d/ hh:mm:ss am/pm"),"
> ",B1)
>
> Result would be
Hi
You can try this.
Column A Column B Column C
5/13/2009 19:33 ABC =CONCATENATE(TEXT(A1,"m/d/ hh:mm:ss am/pm"),"
",B1)
Result would be : 5/13/2009 07:33:00 PM ABC
Regards
Rakesh
On May 12, 12:57 pm, jamadagnira...@gmail.com wrote:
> Hello,
>
> I have a proble
oglegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Jitendra mhashelkar
Sent: Wednesday, May 13, 2009 9:43 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Concatenating Problem
No use Praveen,
Some other idea?
Jitendra
On Wed, May 13, 2009 at 2:42 AM, kvc p
No use Praveen,
Some other idea?
Jitendra
On Wed, May 13, 2009 at 2:42 AM, kvc praveen kumar wrote:
> Just try =A1&B1 in C1.
>
> On Tue, May 12, 2009 at 1:27 PM, wrote:
>
>>
>> Hello,
>>
>> I have a problem in displaying AM or PM, when i try to concatenate to
>> cells. Below is the reference -
Just try =A1&B1 in C1.
On Tue, May 12, 2009 at 1:27 PM, wrote:
>
> Hello,
>
> I have a problem in displaying AM or PM, when i try to concatenate to
> cells. Below is the reference -
>
> Column A Column B Column C
>
> 4/16/2009 9:00 AM CDT 4/16/2009 9:00
Hi Raghu,
Little modification in your formula and it works:-
=CONCATENATE(MONTH(A1),"/",DAY(A1),"/",YEAR(A1),"
",HOUR(A1),":",MINUTE(A1),":",SECOND(A1),":",IF(A1="AM","AM","PM")," ",(B1))
File is attached as well for your quick reference.
Thanks & Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM
Indeed insightful ! Thanks Paul
Just to give a hands-on example of Paul's explanation on converting number
to date using String. Here is how it is, i just tried:
Cell(A1) -- "12/05/2009 " This is a date format
Cell(B1) -- "=TEXT(A1,"MMDD")" ,then in Cell B2, you get the string
pr
Excellent explaination Paul...
Learnt something new today..
Keep up the great work..
Regards,
Andy
On Tue, May 12, 2009 at 7:15 PM, Paul Schreiner wrote:
> First, I want to remind you that the "date/time" isn't being stored as a
> "date".
> Excel stores it as a NUMBER ("4/16/2009 9:00 AM" is s
the number to a date STRING should fix it though.
paul
From: zheng yu
To: excel-macros@googlegroups.com
Sent: Tuesday, May 12, 2009 8:54:55 AM
Subject: $$Excel-Macros$$ Re: Concatenating Problem
Precise! Very useful !
when I export a Date (appears as a
Precise! Very useful !
when I export a Date (appears as a Date format) to XMl..why it appears as
a number 39919.375.any idea on that?
On Tue, May 12, 2009 at 2:15 PM, Paul Schreiner wrote:
> First, I want to remind you that the "date/time" isn't being stored as a
> "date".
> Excel stores
First, I want to remind you that the "date/time" isn't being stored as a "date".
Excel stores it as a NUMBER ("4/16/2009 9:00 AM" is stored as: 39919.375)
But, you're using a cell format of: "m/d/yy h:mm AM/PM" (or similar) to DISPLAY
the number as a date/time.
Excel then checks the fraction of a
12 matches
Mail list logo
