+ Reply to Thread
Results 1 to 2 of 2

Dots between long numbers since change of server

  1. #1
    Registered User
    Join Date
    11-30-2021
    Location
    Heers, Belgium
    MS-Off Ver
    Microsoft® Excel® voor Microsoft 365 MSO (Versie 2110 Build 16.0.14527.20270) 64 bits
    Posts
    1

    Question Dots between long numbers since change of server

    Hello!


    Since our company switched servers, numbers that supposed to look like this -> 2.01170000 suddenly look like this -> 201.170.000
    Excel seems to completely change the values of the downloaded cvs file.

    Unwinking the use , as separator also doesn't work.


    Anyone has experience with this problem?

    Thanks!

  2. #2
    Forum Expert
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    1,418

    Re: Dots between long numbers since change of server

    greeting from cow18.
    So it's a csv and you are using 365 (on all your PC's?)
    You 'd better post a small example of your CSV-file, 10 lines (no private or sensitive data).
    With PQ or something similar, you 'll be able to import it correct.
    Is the name of that CSV always the same or approx. the same ?
    Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula to put dots and colon on text numbers
    By hfung in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-14-2021, 02:32 AM
  2. [SOLVED] adodb connection to sql server.. How long does it stay open when idle
    By Steveapa in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-17-2021, 12:30 PM
  3. [SOLVED] Excel Puts Dots On My Custom Formatted Numbers
    By zanshin777 in forum Excel General
    Replies: 8
    Last Post: 11-09-2018, 11:07 AM
  4. Need long space, dots or dashes b/w two values
    By fassi in forum Excel General
    Replies: 7
    Last Post: 11-24-2011, 06:22 PM
  5. Dots between numbers
    By Ondin in forum Excel General
    Replies: 3
    Last Post: 06-22-2010, 12:41 PM
  6. dots and line to the left of row numbers
    By elizlee in forum Excel General
    Replies: 3
    Last Post: 05-07-2010, 06:32 AM
  7. [SOLVED] Change Dots into Commas as Decimal Divider
    By xenia in forum Excel General
    Replies: 3
    Last Post: 08-08-2005, 04:48 AM

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