| Re: regional settings "Tz" <Tz@discussions.microsoft.com> wrote in message
news:055F9996-69B5-4339-B961-BFD7D356FBB1@microsoft.com...
> Hi thanks for taking the time to read this post. I just switched
> from XP to
> Vista, i input alot of times into Excel and having the time
> separator
> switched from " : " to the decimal in regional settings saves me
> alot of
> time. This feature seems to have been excluded or moved in Vista and
> i cant
> tell you how much time this is costing me, especially because i'm
> already
> used to hitting the decimal on my num pad instead of "shift :" and
> i'm going
> to wear out my backspace button. Any insite to where or how i can
> change the
> time separator from : to . would be much appreciated. i've tried
> regional
> settings and its just not there. thanks in advance
Unless I misunderstand.
Control Panel ... Regional and Language Option ... Customize this
format ... (button) ... Time (tab)
in the Format section where it says initially HH:mm:ss
Just replace the colons with periods and press Apply.
This will change the format.
--
Mike Brannigan |