Windows 10 Enterprise  

Page 1 of 2 12 LastLast

  1. Posts : 10
    Windows 10 Enterprise
       #1

    Windows 10 Enterprise


    Hello,

    I have a problem with my work laptop i change it a couple of weeks ago, and now every time i try and export a report in excel, the numbers are very big, for example instead of 600 it shows me 600000000.
    The problem is with some setting of the pc that is affecting this, because for my coleeagues it is working fine, and the excel version is the same as mine.
    Does anyone knows what settings to change so the numbers will show correct?

    Thanks in advance !!
      My Computer


  2. Posts : 9,746
    Mac OS Catalina
       #2

    Has zero to do with the laptop, it is a excel issue with the worksheet.
      My Computer


  3. Posts : 10
    Windows 10 Enterprise
    Thread Starter
       #3

    bro67 said:
    Has zero to do with the laptop, it is a excel issue with the worksheet.
    Ok,thanks for the info.Do you have any idea or advice on how to fix that issue?
    Thanks !
      My Computer


  4. Posts : 2,092
    Windows 11 Pro (latest update ... forever anal)
       #4

    Sidu5211 said:
    Hello,

    I have a problem with my work laptop i change it a couple of weeks ago, and now every time i try and export a report in excel, the numbers are very big, for example instead of 600 it shows me 600000000.
    The problem is with some setting of the pc that is affecting this, because for my coleeagues it is working fine, and the excel version is the same as mine.
    Does anyone knows what settings to change so the numbers will show correct?

    Thanks in advance !!
    Where was the file(s) saved ? Where are they opened from ? Export to where ? In What format ?

    So much detail required. Suggest seeking help from someoen more experienced in MS Excel (agree with @bro67, problem is with (settings/formatting in) MS Excel).

    EDIT : MS Excel : version ? Registered/activated ?

    EDIT 2 : Although problem also could be with export destination format/file/program ... Export to where ? Export in what format ?
      My Computers


  5. Posts : 10
    Windows 10 Enterprise
    Thread Starter
       #5

    idgat said:
    Where was the file(s) saved ? Where are they opened from ? Export to where ? In What format ?

    So much detail required. Suggest seeking help from someoen more experienced in MS Excel (agree with @bro67, problem is with (settings/formatting in) MS Excel).

    EDIT : MS Excel : version ? Registered/activated ?

    EDIT 2 : Although problem also could be with export destination format/file/program ... Export to where ? Export in what format ?
    So,the file is opened from powerbi, where the numbers are correct.I save it on desktop and then change the csv format to the excel format so i can work on the sheet.
    MS Excel version - 2208 (build 15601.20538 Click-to-run ) Registered and activated.
    Thanks !
      My Computer


  6. Posts : 9,746
    Mac OS Catalina
       #6

    Then it is a issue with Power Bi to CSV is a known issue for Auto Data Type during upload of the data to Power Bi.
      My Computer


  7. Posts : 10
    Windows 10 Enterprise
    Thread Starter
       #7

    bro67 said:
    Then it is a issue with Power Bi to CSV is a known issue for Auto Data Type during upload of the data to Power Bi.
    I see.Do you have any links or something that tells about this issue? I will also look it up from my side.
    Thanks for the answers !
      My Computer


  8. Posts : 16,547
    Windows 10 Home x64 Version 22H2 Build 19045.3930
       #8

    Please clarify what format the file is provided to you & to your colleagues [I am not sure about this from your description].
    - Is it supplied as a csv and then you use Power Bi to do something with it?
    - Do your colleagues also have to do something with Power Bi before using the file in Excel?
    - Is your Power Bi version the same as your colleagues?

    If the file is provided as a csv file then open the csv directly in Excel & then save it as xlsx from within Excel.
    - You can right-click on a csv file and choose Open with, Excel. Then check the effected cell [or cells].
    - If the problem also exists when processed this way, please explain exactly what is in the cell [or cells] affected. Perhaps it is a formula. What formatting is set for the cell [or cells] affected?


    All the best,
    Denis
      My Computer


  9. Posts : 10
    Windows 10 Enterprise
    Thread Starter
       #9

    Try3 said:
    Please clarify what format the file is provided to you & to your colleagues [I am not sure about this from your description].
    - Is it supplied as a csv and then you use Power Bi to do something with it?
    - Do your colleagues also have to do something with Power Bi before using the file in Excel?
    - Is your Power Bi version the same as your colleagues?

    If the file is provided as a csv file then open the csv directly in Excel & then save it as xlsx from within Excel.
    - You can right-click on a csv file and choose Open with, Excel. Then check the effected cell [or cells].
    - If the problem also exists when processed this way, please explain exactly what is in the cell [or cells] affected. Perhaps it is a formula. What formatting is set for the cell [or cells] affected?


    All the best,
    Denis
    So, from PowerBi i export data, i can only do it as an csv file.
    From there i save it as an excel file so i can work on it.This problem only affects me,for my coleagues it is working fine.
    the powerbi version is the same as mine.
    All the cell containing numbers are affected.
    Windows 10 Enterprise-excel.pngWindows 10 Enterprise-pbi.png
    I uploaded pictures so you can have a better idea.

    Thanks !
      My Computer


  10. Posts : 16,547
    Windows 10 Home x64 Version 22H2 Build 19045.3930
       #10

    Sidu5211 said:
    From there
    From where?

    1 If Power Bi saves it as a csv then use Open with, Excel to open it in Excel and then SaveAs xlsx from within Excel.
    2 Do check that the csv file exported for you by Power Bi is the same as your colleagues get. This will help to identify the source of the problem.

    Denis
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd
All times are GMT -5. The time now is 05:12.
Find Us




Windows 10 Forums