Results 1 to 2 of 2

Thread: stops and commas

  1. #1
    Acolyte Brecht's Avatar
    Join Date
    Sep 2014
    Location
    Netherlands
    Posts
    31
    Articles
    0

    stops and commas



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    I have a list of article codes, that have the format of, for example, 1320.786. But when I put them into excel, the format changes to 1.320.299 .
    I read somewhere that it might help to change the cell properties (so that no stops would be used for thousands). But this would remove all the stops.

    Which settings should I use, so that excel shows the article codes properly? (Bear in mind that some of the article codes are of another length, for example 181.026 , 55.221 or 1560 ).

    Thank you in advance!

  2. #2
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Hi,
    Plz see the attachment. I hope it may help you.
    Attached Files Attached Files

Posting Permissions

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