software

I use Excell on 2005 and 97 and had no trouble using the custom format
hh:mm:ss.00 to enter times to the hundredth. I use this to calculat ET for
time trials. In XP i cannot get the spreadsheet to recognize this as a
number. It sees it as text. If I get rid of the decimal and the following
numbers I can make it work but then I must manually calculate the hundredths
inviting errors.

Look in the regional settings in windows, I use XP and have no problems
using
the same format. Not that it should be any difference but the default way of
excel 2003 to format for this is

hh:mm:ss.00;@

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;Excell time calcs to the hundredthsquot; lt;Excell time calcs to the
gt; wrote in message
...
gt;I use Excell on 2005 and 97 and had no trouble using the custom format
gt; hh:mm:ss.00 to enter times to the hundredth. I use this to calculat ET
gt; for
gt; time trials. In XP i cannot get the spreadsheet to recognize this as a
gt; number. It sees it as text. If I get rid of the decimal and the
gt; following
gt; numbers I can make it work but then I must manually calculate the
gt; hundredths
gt; inviting errors.Thanks Peo and I know this should work too. If I email it to my wifes
computer it works just not here on my computer. BTW I have English Canada
set as regional settings. I have had this work in the format you offered as
well as mine hh:mm:ss.00. It just puts the infor into the cell as text IE
left justified.

quot;Peo Sjoblomquot; wrote:

gt; Look in the regional settings in windows, I use XP and have no problems
gt; using
gt; the same format. Not that it should be any difference but the default way of
gt; excel 2003 to format for this is
gt;
gt; hh:mm:ss.00;@
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Northwest Excel Solutions
gt;
gt; www.nwexcelsolutions.com
gt;
gt; (remove ^^ from email address)
gt;
gt; Portland, Oregon
gt;
gt;
gt;
gt;
gt; quot;Excell time calcs to the hundredthsquot; lt;Excell time calcs to the
gt; gt; wrote in message
gt; ...
gt; gt;I use Excell on 2005 and 97 and had no trouble using the custom format
gt; gt; hh:mm:ss.00 to enter times to the hundredth. I use this to calculat ET
gt; gt; for
gt; gt; time trials. In XP i cannot get the spreadsheet to recognize this as a
gt; gt; number. It sees it as text. If I get rid of the decimal and the
gt; gt; following
gt; gt; numbers I can make it work but then I must manually calculate the
gt; gt; hundredths
gt; gt; inviting errors.
gt;
gt;

And you don't have anything set to replace the period under
toolsgt;autocorrect options? Also look under
toolsgt;optionsgt;transitions and make sure you don't have anything checked
there, formula entry screws up date entry

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;Excell time calcs to the hundredthsquot; oft.comgt; wrote in message
...
gt; Thanks Peo and I know this should work too. If I email it to my wifes
gt; computer it works just not here on my computer. BTW I have English Canada
gt; set as regional settings. I have had this work in the format you offered
gt; as
gt; well as mine hh:mm:ss.00. It just puts the infor into the cell as text IE
gt; left justified.
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt;gt; Look in the regional settings in windows, I use XP and have no problems
gt;gt; using
gt;gt; the same format. Not that it should be any difference but the default way
gt;gt; of
gt;gt; excel 2003 to format for this is
gt;gt;
gt;gt; hh:mm:ss.00;@
gt;gt;
gt;gt; --
gt;gt;
gt;gt; Regards,
gt;gt;
gt;gt; Peo Sjoblom
gt;gt;
gt;gt; Northwest Excel Solutions
gt;gt;
gt;gt; www.nwexcelsolutions.com
gt;gt;
gt;gt; (remove ^^ from email address)
gt;gt;
gt;gt; Portland, Oregon
gt;gt;
gt;gt;
gt;gt;
gt;gt;
gt;gt; quot;Excell time calcs to the hundredthsquot; lt;Excell time calcs to the
gt;gt; gt; wrote in message
gt;gt; ...
gt;gt; gt;I use Excell on 2005 and 97 and had no trouble using the custom format
gt;gt; gt; hh:mm:ss.00 to enter times to the hundredth. I use this to calculat ET
gt;gt; gt; for
gt;gt; gt; time trials. In XP i cannot get the spreadsheet to recognize this as a
gt;gt; gt; number. It sees it as text. If I get rid of the decimal and the
gt;gt; gt; following
gt;gt; gt; numbers I can make it work but then I must manually calculate the
gt;gt; gt; hundredths
gt;gt; gt; inviting errors.
gt;gt;
gt;gt;