Re: Truncating leading zeroes

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Barb Reinhardt (breinhardt_at_replytonewsgroup.com)
Date: 12/02/04


Date: Thu, 2 Dec 2004 11:16:59 -0500

I got it to work by formatting the cell for time and changing the locale to
English (United Kingdom), but I'm not sure what else that might do.

"JM" <JM@discussions.microsoft.com> wrote in message
news:CA7FAD83-2F4D-49A1-8F4A-A9B91DC072B1@microsoft.com...
> When I enter time such as 0600 and then tab, the leading zero disappears
> leaving 600. Any suggestions on how to correct this problem?



Relevant Pages

  • Re: SUM(above) bug?
    ... A user had the language in Control Panel>Regional and Language ... It should have been English. ... Blank cell ... Tested on my own PC (English (United Kingdom)) and I got the odd ...
    (microsoft.public.word.docmanagement)
  • OT: Response to Revocation of Independence
    ... TO THE CITIZENS OF THE UNITED KINGDOM OF GREAT BRITAIN AND NORTHERN ... We welcome your concern about our electoral process. ... name "aluminum" for the metal. ... we'll talk about the English and Australian accent issue. ...
    (alt.sports.football.pro.ne-patriots)
  • Re: SUM(above) bug?
    ... A user had the language in Control Panel>Regional and Language ... It should have been English. ... Blank cell ... The formula field at the bottom was doing a couple of odd things; ...
    (microsoft.public.word.docmanagement)
  • Re: Like MODE but not quite.
    ... BLANK means no cell contents, empty means blank or "". ... Which may be relevant in Danish newsgroups, but not in English ... English language versions is no cell contents. ...
    (microsoft.public.excel)
  • Re: local problem in developing GUI
    ... > met some problems when developing GUI software for English Linux OS. ... There are not different versions of Linux for different languages. ... On top of this gettext is commonly-used to translate program ... output into the language specifed by the locale. ...
    (comp.os.linux.development.apps)