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 !!

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

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 !

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 !

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 !

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.

I uploaded pictures so you can have a better idea.

Thanks !