Brecht
Member
- Joined
- Sep 15, 2014
- Messages
- 36
- Reaction score
- 0
- Points
- 6
- Location
- Netherlands
- Excel Version(s)
- Version 2007
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!
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!