BIM Coordinator Program (INT) April 22, 2024
Find the next step in your career as a Graphisoft Certified BIM Coordinator!
Collaboration with other software
About model and data exchange with 3rd party solutions: Revit, Solibri, dRofus, Bluebeam, structural analysis solutions, and IFC, BCF and DXF/DWG-based exchange, etc.

Saving Quantity Lists from AC to Excel

Anonymous
Not applicable
Hi guys!

I'm experiencing a rather irritating and possibly very stupid problem.
When I export a simple schedule of zone areas into XLSX format it saves ok.
When opened in Excel though every number that is not whole ("23,56" for example) is changed to only "23".

Any ideas?
Am I explaining it clear enough?

Thanks a lot!
4 REPLIES 4
Laszlo Nagy
Community Admin
Community Admin
Can you format those cells in Excel to display them as Number with 2 decimal places? Maybe by default it displays them to zero decimal places.

When you select any cell you can see its value in the Formula Bar located under the Ribbon. That shows its true value. What you see displayed in the cells are a matter of cell formatting.
Loving Archicad since 1995 - Find Archicad Tips at x.com/laszlonagy
AMD Ryzen9 5900X CPU, 64 GB RAM 3600 MHz, Nvidia GTX 1060 6GB, 500 GB NVMe SSD
2x28" (2560x1440), Windows 10 PRO ENG, Ac20-Ac27
Anonymous
Not applicable
The cells' formatting is correct - with two decimals after the coma.

I've just tried doing the same operation from my laptop at home and here everything is fine.
I'll consider this a bug in my workstation in the office.

Thanks you anyway!
Laszlo Nagy
Community Admin
Community Admin
Could it be something that is different in your operating system settings? The way numbers are set to be formatted maybe?
Loving Archicad since 1995 - Find Archicad Tips at x.com/laszlonagy
AMD Ryzen9 5900X CPU, 64 GB RAM 3600 MHz, Nvidia GTX 1060 6GB, 500 GB NVMe SSD
2x28" (2560x1440), Windows 10 PRO ENG, Ac20-Ac27
Barry Kelly
Moderator
It seems someone else was just having the same problem.

http://archicad-talk.graphisoft.com/viewtopic.php?t=53250

Are you using version 19 as well?
Check you have the latest update installed.

Barry.
One of the forum moderators.
Versions 6.5 to 27
Dell XPS- i7-6700 @ 3.4Ghz, 16GB ram, GeForce GTX 960 (2GB), Windows 10
Lenovo Thinkpad - i7-1270P 2.20 GHz, 32GB RAM, Nvidia T550, Windows 11
Learn and get certified!