>>When I view the result of the energy balance analysis on the software screen, the unit appears as million gigajoules, and when I say export to excel, the unit is changed to gigajoule.
This is fixed in LEAP2020.1.3, which i just uploaded. Please can you download that and try it out?