Results 1 to 10 of 10
  1. #1
    New Lounger
    Join Date
    Dec 2009
    Location
    NSW Australia
    Posts
    9
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Wink Leading zeros in variable-length part numbers

    Hi all,
    I need to copy variable length Part Numbers beginning with a variable number of zeroes from Outlook/Word 2007 to Excel 2007 Help!

    I can: Paste into Notepad. Format Excel cells as text then paste from Notepad to Excel.
    or: I can also do "Paste Special", "Text".

    Also either of these method leave the cell with the Very annoying "numbers stored as text" error message .

    As I have to copy the P/No's. again, the ERROR message comes back.



    Mumble mumble, Stomp, Mumble, munble, stomp.......... slams bedroom door.

    Regards.
    NotHarry.

  2. #2
    4 Star Lounger pccoyle's Avatar
    Join Date
    Apr 2001
    Location
    Auckland, Auckland, New Zealand
    Posts
    535
    Thanks
    3
    Thanked 2 Times in 2 Posts
    Have you tried exporting the file to excel, chossing say space or comma deliminated instead of pasting - (or import into excel form the saved file :-)
    Paul Coyle
    Approach love and cooking with reckless abandon

  3. #3
    New Lounger
    Join Date
    Dec 2009
    Location
    NSW Australia
    Posts
    9
    Thanks
    3
    Thanked 0 Times in 0 Posts
    More Info please? For office 2007.
    Thanks.

    Regards,
    NotHarry
    .

  4. #4
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts
    Hi NotHarry,

    Any reason you can't simply paste the numbers as values and format the cells with the required # of 0s? For example, a cell containing 12345 but custom-formatted with 000000 will display 012345.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  5. #5
    New Lounger
    Join Date
    Dec 2009
    Location
    NSW Australia
    Posts
    9
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Leading zero's in variable length "Part Numbers" :-)

  6. #6
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    988
    Thanks
    56
    Thanked 105 Times in 90 Posts
    Why not simply disable that specific error message ?

    http://support.microsoft.com/kb/291361

  7. The Following User Says Thank You to MartinM For This Useful Post:

    mwpotter (2011-01-31)

  8. #7
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,170
    Thanks
    47
    Thanked 978 Times in 908 Posts
    As they are part numbers you can treat them as text. Have you tried a single quote in front of the number? e.g. '000236743

    cheers, Paul

  9. The Following User Says Thank You to Paul T For This Useful Post:

    mwpotter (2011-01-31)

  10. #8
    4 Star Lounger pccoyle's Avatar
    Join Date
    Apr 2001
    Location
    Auckland, Auckland, New Zealand
    Posts
    535
    Thanks
    3
    Thanked 2 Times in 2 Posts
    Under data there should be a file import option. Use his, point to the file with the text and import into colums and format the numbers as mentioned in other posts. HTH
    Paul Coyle
    Approach love and cooking with reckless abandon

  11. The Following User Says Thank You to pccoyle For This Useful Post:

    mwpotter (2011-01-31)

  12. #9
    New Lounger
    Join Date
    Dec 2009
    Location
    NSW Australia
    Posts
    9
    Thanks
    3
    Thanked 0 Times in 0 Posts
    So..... Not very elegant, but it works.
    I suppose I had hoped for a "NON Numeric” number format.
    Or a number format that retained the typed/entered data exactly as entered, called perhaps "Literal Number" format, could have decimal places and accept 0~9 and a~Z (useful for non decimal number systems. :-)

    Thanks again everyone.

  13. #10
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    A non-numeric format is the "Text" format and it accepts numbers, decimals, and letters.

    The only time one should really use a numeric format is when the value is a number that can be manipulated (like a date). Credit card numbers, phone numbers, soc security numbers, part numbers, etc are all types of non-numeric data that should be in text format...

    Steve

Posting Permissions

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