software

Is it possible for me to enter quot;1353quot; in cell A1 and it will
automatically display 1:53PM in cell A1? This would help a bunch.
Thanks.--
exsam21
------------------------------------------------------------------------
exsam21's Profile: www.excelforum.com/member.php...oamp;userid=22666
View this thread: www.excelforum.com/showthread...hreadid=502566Chip Pearson has some code that may help you:
cpearson.com/excel/DateTimeEntry.htm

If you're new to macros, you may want to read David McRitchie's intro at:
www.mvps.org/dmcritchie/excel/getstarted.htm

exsam21 wrote:
gt;
gt; Is it possible for me to enter quot;1353quot; in cell A1 and it will
gt; automatically display 1:53PM in cell A1? This would help a bunch.
gt; Thanks.
gt;
gt; --
gt; exsam21
gt; ------------------------------------------------------------------------
gt; exsam21's Profile: www.excelforum.com/member.php...oamp;userid=22666
gt; View this thread: www.excelforum.com/showthread...hreadid=502566

--

Dave Peterson


Thank you very much!--
exsam21
------------------------------------------------------------------------
exsam21's Profile: www.excelforum.com/member.php...oamp;userid=22666
View this thread: www.excelforum.com/showthread...hreadid=502566I can't think of a way except via macro but you could use a formula in B1
formated the way you want...
=TIMEVALUE(LEFT(A1,LEN(A1)-2)amp;quot;:quot;amp;RIGHT(A1,2))

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.quot;exsam21quot; wrote:

gt;
gt; Is it possible for me to enter quot;1353quot; in cell A1 and it will
gt; automatically display 1:53PM in cell A1? This would help a bunch.
gt; Thanks.
gt;
gt;
gt; --
gt; exsam21
gt; ------------------------------------------------------------------------
gt; exsam21's Profile: www.excelforum.com/member.php...oamp;userid=22666
gt; View this thread: www.excelforum.com/showthread...hreadid=502566
gt;
gt;