+ Reply to Thread
Results 1 to 4 of 4

Excel number format problems

  1. #1
    Annoyed !!!
    Guest

    Excel number format problems

    If I want to use a number with 8 digits and a leading zero I've set up a
    custom format using 8 zeros. Trouble is as soon as I go out of format option
    the cell formatting changes to Greek. The leading zeros are retained but
    dissapear when I use the info on the worksheet to merge to labels or other
    Word documents.

    How do I retain my custom cell formatting ????

  2. #2
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,196
    Set the cell formula to 'text' - ie:

    =Text(A1*A2,"00000000")

    or

    =Text( your calculation ,"00000000")

    --


    Quote Originally Posted by Annoyed !!!
    If I want to use a number with 8 digits and a leading zero I've set up a
    custom format using 8 zeros. Trouble is as soon as I go out of format option
    the cell formatting changes to Greek. The leading zeros are retained but
    dissapear when I use the info on the worksheet to merge to labels or other
    Word documents.

    How do I retain my custom cell formatting ????

  3. #3
    Annoyed !!!
    Guest

    Re: Excel number format problems

    That would be fine if I wasn't using a simple formula in the cells as well.
    It's a basic six digit date code with an extra two digits to determine
    chronological order of production on batch number labels.

    I've set it up so that it does a simple calculation =B7+1 for instance where
    B7 is the cell immediately above in the column so that it continues down the
    column when copied and pasted adding one number at a time. It needs to be
    flexible as some start with 0 if the day is 1 to 9 in the month. If I could
    only retain the custom number format instead of it changing to Greek all the
    time it would be fine.

    "Bryan Hessey" wrote:

    >
    > Set the cell formula to 'text' - ie:
    >
    > =Text(A1*A2,"00000000")
    >
    > or
    >
    > =Text( your calculation ,"00000000")
    >
    > --
    >
    >
    > Annoyed !!! Wrote:
    > > If I want to use a number with 8 digits and a leading zero I've set up
    > > a
    > > custom format using 8 zeros. Trouble is as soon as I go out of format
    > > option
    > > the cell formatting changes to Greek. The leading zeros are retained
    > > but
    > > dissapear when I use the info on the worksheet to merge to labels or
    > > other
    > > Word documents.
    > >
    > > How do I retain my custom cell formatting ????

    >
    >
    > --
    > Bryan Hessey
    > ------------------------------------------------------------------------
    > Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
    > View this thread: http://www.excelforum.com/showthread...hreadid=540617
    >
    >


  4. #4
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,196
    Did you try

    =TEXT(B7+1,"00000000")

    in B8 ?

    --


    Quote Originally Posted by Annoyed !!!
    That would be fine if I wasn't using a simple formula in the cells as well.
    It's a basic six digit date code with an extra two digits to determine
    chronological order of production on batch number labels.

    I've set it up so that it does a simple calculation =B7+1 for instance where
    B7 is the cell immediately above in the column so that it continues down the
    column when copied and pasted adding one number at a time. It needs to be
    flexible as some start with 0 if the day is 1 to 9 in the month. If I could
    only retain the custom number format instead of it changing to Greek all the
    time it would be fine.

    "Bryan Hessey" wrote:

    >
    > Set the cell formula to 'text' - ie:
    >
    > =Text(A1*A2,"00000000")
    >
    > or
    >
    > =Text( your calculation ,"00000000")
    >
    > --
    >
    >
    > Annoyed !!! Wrote:
    > > If I want to use a number with 8 digits and a leading zero I've set up
    > > a
    > > custom format using 8 zeros. Trouble is as soon as I go out of format
    > > option
    > > the cell formatting changes to Greek. The leading zeros are retained
    > > but
    > > dissapear when I use the info on the worksheet to merge to labels or
    > > other
    > > Word documents.
    > >
    > > How do I retain my custom cell formatting ????

    >
    >
    > --
    > Bryan Hessey
    > ------------------------------------------------------------------------
    > Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
    > View this thread: http://www.excelforum.com/showthread...hreadid=540617
    >
    >

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1