software

Is there any way that I can format a cell to insert a colon three spaces to
the left from the end of any group of numbers that I type in the a cell?
Examples 9:15 10:15

Thanks in advance,
Gordon
As confusing as it would be to do that, you can use a custom number format of

#\:##

915 will appear as 9:15, and 1015 will appear as 10:15. Is that what you
wanted? Why would you do that though? Excel is very handy when dealing with
time.

quot;BigBuck98quot; wrote:

gt; Is there any way that I can format a cell to insert a colon three spaces to
gt; the left from the end of any group of numbers that I type in the a cell?
gt; Examples 9:15 10:15
gt;
gt; Thanks in advance,
gt; Gordon
gt;
gt;
gt;

Sloth,
I have tried to format the cell with the time formats, but I can't seem to
get anything to work. I just want to type in 915 and have it show 9:15 or
1015 and have it show 10:15. I there a better way to do this?

Gordon

quot;Slothquot; gt; wrote in message
...
gt; As confusing as it would be to do that, you can use a custom number format
gt; of
gt;
gt; #\:##
gt;
gt; 915 will appear as 9:15, and 1015 will appear as 10:15. Is that what you
gt; wanted? Why would you do that though? Excel is very handy when dealing
gt; with
gt; time.
gt;
gt; quot;BigBuck98quot; wrote:
gt;
gt;gt; Is there any way that I can format a cell to insert a colon three spaces
gt;gt; to
gt;gt; the left from the end of any group of numbers that I type in the a cell?
gt;gt; Examples 9:15 10:15
gt;gt;
gt;gt; Thanks in advance,
gt;gt; Gordon
gt;gt;
gt;gt;
gt;gt;
I didn't say use a time format. Use a CUSTOM format and input this as your
custom format

#\:##

Then when you enter a number in the cell in will show with a ':' inserted as
you described.

quot;BigBuck98quot; wrote:

gt; Sloth,
gt; I have tried to format the cell with the time formats, but I can't seem to
gt; get anything to work. I just want to type in 915 and have it show 9:15 or
gt; 1015 and have it show 10:15. I there a better way to do this?
gt;
gt; Gordon
gt;
gt; quot;Slothquot; gt; wrote in message
gt; ...
gt; gt; As confusing as it would be to do that, you can use a custom number format
gt; gt; of
gt; gt;
gt; gt; #\:##
gt; gt;
gt; gt; 915 will appear as 9:15, and 1015 will appear as 10:15. Is that what you
gt; gt; wanted? Why would you do that though? Excel is very handy when dealing
gt; gt; with
gt; gt; time.
gt; gt;
gt; gt; quot;BigBuck98quot; wrote:
gt; gt;
gt; gt;gt; Is there any way that I can format a cell to insert a colon three spaces
gt; gt;gt; to
gt; gt;gt; the left from the end of any group of numbers that I type in the a cell?
gt; gt;gt; Examples 9:15 10:15
gt; gt;gt;
gt; gt;gt; Thanks in advance,
gt; gt;gt; Gordon
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

Gordon

You can have 915 show as 9:15 using a custom format, but it will not be a valid
time.

Only through VBA can you quick-enter dates/times as you want.

See Chip Pearson's site for this.

www.cpearson.com/excel/DateTimeEntry.htmGord Dibben MS Excel MVP

On Thu, 12 Jan 2006 13:16:13 -0500, quot;BigBuck98quot; gt; wrote:

gt;Sloth,
gt;I have tried to format the cell with the time formats, but I can't seem to
gt;get anything to work. I just want to type in 915 and have it show 9:15 or
gt;1015 and have it show 10:15. I there a better way to do this?
gt;
gt;Gordon
gt;
gt;quot;Slothquot; gt; wrote in message
...
gt;gt; As confusing as it would be to do that, you can use a custom number format
gt;gt; of
gt;gt;
gt;gt; #\:##
gt;gt;
gt;gt; 915 will appear as 9:15, and 1015 will appear as 10:15. Is that what you
gt;gt; wanted? Why would you do that though? Excel is very handy when dealing
gt;gt; with
gt;gt; time.
gt;gt;
gt;gt; quot;BigBuck98quot; wrote:
gt;gt;
gt;gt;gt; Is there any way that I can format a cell to insert a colon three spaces
gt;gt;gt; to
gt;gt;gt; the left from the end of any group of numbers that I type in the a cell?
gt;gt;gt; Examples 9:15 10:15
gt;gt;gt;
gt;gt;gt; Thanks in advance,
gt;gt;gt; Gordon
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;Sloth,
I guess you misread my second post. I got the CUSTOM format to work the way
you described. When I mentioned that I couldn't get the time format to work
that was in reply to your question, quot;Why would you do that though? Excel is
very handy when dealing with time.quot; Before you told me how to do it, I tried
various time format methods and couldn't get anything to work. I have a
database for keeping my blood pressure. I take the pressure three times a
day, (morning, afternoon and evening). I enter the reading and also the time
taken.
Thanks for your help.
Gordon

Slothquot; gt; wrote in message
...
gt;I didn't say use a time format. Use a CUSTOM format and input this as your
gt; custom format
gt;
gt; #\:##
gt;
gt; Then when you enter a number in the cell in will show with a ':' inserted
gt; as
gt; you described.
gt;
gt; quot;BigBuck98quot; wrote:
gt;
gt;gt; Sloth,
gt;gt; I have tried to format the cell with the time formats, but I can't seem
gt;gt; to
gt;gt; get anything to work. I just want to type in 915 and have it show 9:15 or
gt;gt; 1015 and have it show 10:15. I there a better way to do this?
gt;gt;
gt;gt; Gordon
gt;gt;
gt;gt; quot;Slothquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; As confusing as it would be to do that, you can use a custom number
gt;gt; gt; format
gt;gt; gt; of
gt;gt; gt;
gt;gt; gt; #\:##
gt;gt; gt;
gt;gt; gt; 915 will appear as 9:15, and 1015 will appear as 10:15. Is that what
gt;gt; gt; you
gt;gt; gt; wanted? Why would you do that though? Excel is very handy when
gt;gt; gt; dealing
gt;gt; gt; with
gt;gt; gt; time.
gt;gt; gt;
gt;gt; gt; quot;BigBuck98quot; wrote:
gt;gt; gt;
gt;gt; gt;gt; Is there any way that I can format a cell to insert a colon three
gt;gt; gt;gt; spaces
gt;gt; gt;gt; to
gt;gt; gt;gt; the left from the end of any group of numbers that I type in the a
gt;gt; gt;gt; cell?
gt;gt; gt;gt; Examples 9:15 10:15
gt;gt; gt;gt;
gt;gt; gt;gt; Thanks in advance,
gt;gt; gt;gt; Gordon
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;