A blank field that actually contains a NULL value is handled differently. You can overcome this in two ways:
- In the Summary, select the Options > View to show Null values as 0^or as " ", and then export to CSV format. Excel should read this correctly as a zero or space as desired.
- In the Options > Export settings, check the version of the Excel export driver that you're using.
Hope this helps,