Decimal places in Calculated Field

B

Bill

Hi All,

Can anyone tell me how to control the number of decimal places that are
displayed in a calculated field please.

Ta.
Bill
 
B

Bill

Just to add that I have used Round and FormatNumber and though I can get the
right result I need to export it all to Excel and in that it is going in as
text, even when I use format number as the last statement!!!

Help please!!
Bill
 
B

Baz

FormatNumber returns a string, so of course it exports as text!

If you want to export a number to Excel, then export it as a number without
formatting. Access cannot control how Excel displays the number, you will
need to set the appropriate formatting within Excel.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split form 0
Excel does not accept text format! 0
Mail Merge - displaying a conditional number of decimals 5
Number of decimal places output 8
Decimal places in calculated fields 6
Overflow error on calculate field in query - Help Please 1
Decimal format 3
dropdown decimal places 7

Top