<div>
&quot;when I export it, the total column will not display as numbers&quot;<br />
<br />
What do you get then?
</div>


"when I export it, the total column will not display as numbers"

What do you get then?

<div>
&lt;&quot;when I export it, the total column will not display as numbers&quot;<br />
What do you get then?&gt;<br />
<br />
Yeah, I'm curious as well, ...unless one of your fields is a string and you are inputting text (ex.: 45b, X41), then you will get #error<br />
<br />
But even if both fields were text and you only input numeric values, your formula should only output numbers.
</div>


<"when I export it, the total column will not display as numbers"
What do you get then?>

Yeah, I'm curious as well, ...unless one of your fields is a string and you are inputting text (ex.: 45b, X41), then you will get #error

But even if both fields were text and you only input numeric values, your formula should only output numbers.

<div>
<div class="content wysiwyg-content">
I have a left joined query that contains a simple calculated field Nz([CERTIFIED_US_AMT]-Nz([<wbr />DEOB_AMT])<wbr />) &nbsp;with field named &quot;Total&quot;. The two tables are humongous (almost 5 million records each) but still only add up to 1.8GB so it within Ms Access limits. BUT, when I export it, the total column will not display as numbers. I tried to use the &quot;convert to Numbers&quot; feature with no success. Never had this problem before. Query is attached.
</div>
</div>


I have a left joined query that contains a simple calculated field Nz([CERTIFIED_US_AMT]-Nz([DEOB_AMT]))  with field named "Total". The two tables are humongous (almost 5 million records each) but still only add up to 1.8GB so it within Ms Access limits. BUT, when I export it, the total column will not display as numbers. I tried to use the "convert to Numbers" feature with no success. Never had this problem before. Query is attached.

Exported ms access 2007 to Excel 2007 query fails to display as numbers

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.