How to convert DATE and TIME to text

**ice_pack** · 08-12-2005, 06:19 AM

Hi,

I am having problem to convert cells with DATE and TIME format to text. I tried virtually anything but VBA programming. Anybody can help with simpler methods ?

Thanks a lot

**humejap** · 08-12-2005, 07:07 AM

Have you tried using the TEXT function?

e.g.

=TEXT(A1,"DD/MM/YYYY HH:MM:SS")

Assuming cell A1 contains date/time entry

Duke Carey · 08-12-2005, 08:05 AM

Use the TEXT() function

To convert a date value

=TEXT(TODAY(),"MM/DD/YY")

Same thing with time

=TEXT(NOW(),"hh:mm:ss")

"ice_pack" wrote:

>
> Hi,
>
> I am having problem to convert cells with DATE and TIME format to text.
> I tried virtually anything but VBA programming. Anybody can help with
> simpler methods ?
>
> Thanks a lot
>
>
> --
> ice_pack
> ------------------------------------------------------------------------
> ice_pack's Profile: http://www.excelforum.com/member.php...o&userid=26232
> View this thread: http://www.excelforum.com/showthread...hreadid=395275
>
>

**ice_pack** · 08-15-2005, 05:30 AM

Did that, no avail. #NAME? error

Here's my worksheet looks like :

Date (cell A1)

8/9/2005 (cell A3, DATE format MM/DD/YYY)
8/10/2005 (cell A4, same DATE format as above)

If at cell C3 and C4 I want to display same date, but with TEXT format, above formula won't work.

Any idea why ?

Thanks for the reply

Duke Carey · 09-05-2005, 10:05 PM

Use the TEXT() function

To convert a date value

=TEXT(TODAY(),"MM/DD/YY")

Same thing with time

=TEXT(NOW(),"hh:mm:ss")

"ice_pack" wrote:

>
> Hi,
>
> I am having problem to convert cells with DATE and TIME format to text.
> I tried virtually anything but VBA programming. Anybody can help with
> simpler methods ?
>
> Thanks a lot
>
>
> --
> ice_pack
> ------------------------------------------------------------------------
> ice_pack's Profile: http://www.excelforum.com/member.php...o&userid=26232
> View this thread: http://www.excelforum.com/showthread...hreadid=395275
>
>

Duke Carey · 09-05-2005, 11:05 PM

Use the TEXT() function

To convert a date value

=TEXT(TODAY(),"MM/DD/YY")

Same thing with time

=TEXT(NOW(),"hh:mm:ss")

"ice_pack" wrote:

>
> Hi,
>
> I am having problem to convert cells with DATE and TIME format to text.
> I tried virtually anything but VBA programming. Anybody can help with
> simpler methods ?
>
> Thanks a lot
>
>
> --
> ice_pack
> ------------------------------------------------------------------------
> ice_pack's Profile: http://www.excelforum.com/member.php...o&userid=26232
> View this thread: http://www.excelforum.com/showthread...hreadid=395275
>
>

Duke Carey · 09-06-2005, 12:05 AM

Use the TEXT() function

To convert a date value

=TEXT(TODAY(),"MM/DD/YY")

Same thing with time

=TEXT(NOW(),"hh:mm:ss")

"ice_pack" wrote:

>
> Hi,
>
> I am having problem to convert cells with DATE and TIME format to text.
> I tried virtually anything but VBA programming. Anybody can help with
> simpler methods ?
>
> Thanks a lot
>
>
> --
> ice_pack
> ------------------------------------------------------------------------
> ice_pack's Profile: http://www.excelforum.com/member.php...o&userid=26232
> View this thread: http://www.excelforum.com/showthread...hreadid=395275
>
>

Duke Carey · 09-06-2005, 01:05 AM

Use the TEXT() function

To convert a date value

=TEXT(TODAY(),"MM/DD/YY")

Same thing with time

=TEXT(NOW(),"hh:mm:ss")

"ice_pack" wrote:

>
> Hi,
>
> I am having problem to convert cells with DATE and TIME format to text.
> I tried virtually anything but VBA programming. Anybody can help with
> simpler methods ?
>
> Thanks a lot
>
>
> --
> ice_pack
> ------------------------------------------------------------------------
> ice_pack's Profile: http://www.excelforum.com/member.php...o&userid=26232
> View this thread: http://www.excelforum.com/showthread...hreadid=395275
>
>

Duke Carey · 09-06-2005, 02:05 AM

Use the TEXT() function

To convert a date value

=TEXT(TODAY(),"MM/DD/YY")

Same thing with time

=TEXT(NOW(),"hh:mm:ss")

"ice_pack" wrote:

>
> Hi,
>
> I am having problem to convert cells with DATE and TIME format to text.
> I tried virtually anything but VBA programming. Anybody can help with
> simpler methods ?
>
> Thanks a lot
>
>
> --
> ice_pack
> ------------------------------------------------------------------------
> ice_pack's Profile: http://www.excelforum.com/member.php...o&userid=26232
> View this thread: http://www.excelforum.com/showthread...hreadid=395275
>
>

Duke Carey · 09-06-2005, 03:05 AM

Use the TEXT() function

To convert a date value

=TEXT(TODAY(),"MM/DD/YY")

Same thing with time

=TEXT(NOW(),"hh:mm:ss")

"ice_pack" wrote:

>
> Hi,
>
> I am having problem to convert cells with DATE and TIME format to text.
> I tried virtually anything but VBA programming. Anybody can help with
> simpler methods ?
>
> Thanks a lot
>
>
> --
> ice_pack
> ------------------------------------------------------------------------
> ice_pack's Profile: http://www.excelforum.com/member.php...o&userid=26232
> View this thread: http://www.excelforum.com/showthread...hreadid=395275
>
>

Duke Carey · 09-06-2005, 04:05 AM

Use the TEXT() function

To convert a date value

=TEXT(TODAY(),"MM/DD/YY")

Same thing with time

=TEXT(NOW(),"hh:mm:ss")

"ice_pack" wrote:

>
> Hi,
>
> I am having problem to convert cells with DATE and TIME format to text.
> I tried virtually anything but VBA programming. Anybody can help with
> simpler methods ?
>
> Thanks a lot
>
>
> --
> ice_pack
> ------------------------------------------------------------------------
> ice_pack's Profile: http://www.excelforum.com/member.php...o&userid=26232
> View this thread: http://www.excelforum.com/showthread...hreadid=395275
>
>

Duke Carey · 09-06-2005, 06:05 AM

Use the TEXT() function

To convert a date value

=TEXT(TODAY(),"MM/DD/YY")

Same thing with time

=TEXT(NOW(),"hh:mm:ss")

"ice_pack" wrote:

>
> Hi,
>
> I am having problem to convert cells with DATE and TIME format to text.
> I tried virtually anything but VBA programming. Anybody can help with
> simpler methods ?
>
> Thanks a lot
>
>
> --
> ice_pack
> ------------------------------------------------------------------------
> ice_pack's Profile: http://www.excelforum.com/member.php...o&userid=26232
> View this thread: http://www.excelforum.com/showthread...hreadid=395275
>
>

Duke Carey · 09-06-2005, 07:05 AM

Use the TEXT() function

To convert a date value

=TEXT(TODAY(),"MM/DD/YY")

Same thing with time

=TEXT(NOW(),"hh:mm:ss")

"ice_pack" wrote:

>
> Hi,
>
> I am having problem to convert cells with DATE and TIME format to text.
> I tried virtually anything but VBA programming. Anybody can help with
> simpler methods ?
>
> Thanks a lot
>
>
> --
> ice_pack
> ------------------------------------------------------------------------
> ice_pack's Profile: http://www.excelforum.com/member.php...o&userid=26232
> View this thread: http://www.excelforum.com/showthread...hreadid=395275
>
>

Duke Carey · 09-06-2005, 10:05 AM

Use the TEXT() function

To convert a date value

=TEXT(TODAY(),"MM/DD/YY")

Same thing with time

=TEXT(NOW(),"hh:mm:ss")

"ice_pack" wrote:

>
> Hi,
>
> I am having problem to convert cells with DATE and TIME format to text.
> I tried virtually anything but VBA programming. Anybody can help with
> simpler methods ?
>
> Thanks a lot
>
>
> --
> ice_pack
> ------------------------------------------------------------------------
> ice_pack's Profile: http://www.excelforum.com/member.php...o&userid=26232
> View this thread: http://www.excelforum.com/showthread...hreadid=395275
>
>

Duke Carey · 09-06-2005, 11:05 AM

Use the TEXT() function

To convert a date value

=TEXT(TODAY(),"MM/DD/YY")

Same thing with time

=TEXT(NOW(),"hh:mm:ss")

"ice_pack" wrote:

>
> Hi,
>
> I am having problem to convert cells with DATE and TIME format to text.
> I tried virtually anything but VBA programming. Anybody can help with
> simpler methods ?
>
> Thanks a lot
>
>
> --
> ice_pack
> ------------------------------------------------------------------------
> ice_pack's Profile: http://www.excelforum.com/member.php...o&userid=26232
> View this thread: http://www.excelforum.com/showthread...hreadid=395275
>
>

Duke Carey · 09-06-2005, 12:05 PM

Use the TEXT() function

To convert a date value

=TEXT(TODAY(),"MM/DD/YY")

Same thing with time

=TEXT(NOW(),"hh:mm:ss")

"ice_pack" wrote:

>
> Hi,
>
> I am having problem to convert cells with DATE and TIME format to text.
> I tried virtually anything but VBA programming. Anybody can help with
> simpler methods ?
>
> Thanks a lot
>
>
> --
> ice_pack
> ------------------------------------------------------------------------
> ice_pack's Profile: http://www.excelforum.com/member.php...o&userid=26232
> View this thread: http://www.excelforum.com/showthread...hreadid=395275
>
>

Duke Carey · 09-06-2005, 02:05 PM

Use the TEXT() function

To convert a date value

=TEXT(TODAY(),"MM/DD/YY")

Same thing with time

=TEXT(NOW(),"hh:mm:ss")

"ice_pack" wrote:

>
> Hi,
>
> I am having problem to convert cells with DATE and TIME format to text.
> I tried virtually anything but VBA programming. Anybody can help with
> simpler methods ?
>
> Thanks a lot
>
>
> --
> ice_pack
> ------------------------------------------------------------------------
> ice_pack's Profile: http://www.excelforum.com/member.php...o&userid=26232
> View this thread: http://www.excelforum.com/showthread...hreadid=395275
>
>

Duke Carey · 09-06-2005, 03:05 PM

Use the TEXT() function

To convert a date value

=TEXT(TODAY(),"MM/DD/YY")

Same thing with time

=TEXT(NOW(),"hh:mm:ss")

"ice_pack" wrote:

>
> Hi,
>
> I am having problem to convert cells with DATE and TIME format to text.
> I tried virtually anything but VBA programming. Anybody can help with
> simpler methods ?
>
> Thanks a lot
>
>
> --
> ice_pack
> ------------------------------------------------------------------------
> ice_pack's Profile: http://www.excelforum.com/member.php...o&userid=26232
> View this thread: http://www.excelforum.com/showthread...hreadid=395275
>
>

Duke Carey · 09-06-2005, 04:05 PM

Use the TEXT() function

To convert a date value

=TEXT(TODAY(),"MM/DD/YY")

Same thing with time

=TEXT(NOW(),"hh:mm:ss")

"ice_pack" wrote:

>
> Hi,
>
> I am having problem to convert cells with DATE and TIME format to text.
> I tried virtually anything but VBA programming. Anybody can help with
> simpler methods ?
>
> Thanks a lot
>
>
> --
> ice_pack
> ------------------------------------------------------------------------
> ice_pack's Profile: http://www.excelforum.com/member.php...o&userid=26232
> View this thread: http://www.excelforum.com/showthread...hreadid=395275
>
>

Duke Carey · 09-06-2005, 06:05 PM

Use the TEXT() function

To convert a date value

=TEXT(TODAY(),"MM/DD/YY")

Same thing with time

=TEXT(NOW(),"hh:mm:ss")

"ice_pack" wrote:

>
> Hi,
>
> I am having problem to convert cells with DATE and TIME format to text.
> I tried virtually anything but VBA programming. Anybody can help with
> simpler methods ?
>
> Thanks a lot
>
>
> --
> ice_pack
> ------------------------------------------------------------------------
> ice_pack's Profile: http://www.excelforum.com/member.php...o&userid=26232
> View this thread: http://www.excelforum.com/showthread...hreadid=395275
>
>

Duke Carey · 09-06-2005, 07:05 PM

Use the TEXT() function

To convert a date value

=TEXT(TODAY(),"MM/DD/YY")

Same thing with time

=TEXT(NOW(),"hh:mm:ss")

"ice_pack" wrote:

>
> Hi,
>
> I am having problem to convert cells with DATE and TIME format to text.
> I tried virtually anything but VBA programming. Anybody can help with
> simpler methods ?
>
> Thanks a lot
>
>
> --
> ice_pack
> ------------------------------------------------------------------------
> ice_pack's Profile: http://www.excelforum.com/member.php...o&userid=26232
> View this thread: http://www.excelforum.com/showthread...hreadid=395275
>
>

How to convert DATE and TIME to text

LinkBack

Thread Tools

Rate This Thread

Display

How to convert DATE and TIME to text

Use TEXT function

RE: How to convert DATE and TIME to text

RE: How to convert DATE and TIME to text

RE: How to convert DATE and TIME to text

RE: How to convert DATE and TIME to text

RE: How to convert DATE and TIME to text

RE: How to convert DATE and TIME to text

RE: How to convert DATE and TIME to text

RE: How to convert DATE and TIME to text

RE: How to convert DATE and TIME to text

RE: How to convert DATE and TIME to text

RE: How to convert DATE and TIME to text

RE: How to convert DATE and TIME to text

RE: How to convert DATE and TIME to text

RE: How to convert DATE and TIME to text

RE: How to convert DATE and TIME to text

RE: How to convert DATE and TIME to text

RE: How to convert DATE and TIME to text

RE: How to convert DATE and TIME to text

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions