Having the exact same issue. All numbers in cells are preceded by an '=' which then appears as zeros in the cells when I email it to colleagues. Only if they click into a specific cell do they see e.g. '=1540' otherwise it appears as 0.

QBO team - we all pay a premium to you every month, don't tell busy people to clear caches, email excel sheets around, and harass Microsoft - just fix your own problem! There's enough paying customers here for you to have all the data you need to sort yours bug out - it's an essential report.