Forum Discussion

AmptivaInc's avatar
AmptivaInc
Qrew Cadet
8 years ago

limit numeric digit count when exporting data to excel

I have several numeric formula fields that have been set up to display only one digit after the decimal.  The issue is that when exported to excel, all of these fields are displaying two digits after ...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
Like Excel, Quick Base calculates to many decimal places and  in the display format you can set it to only show say 1 decimal place.  But under the covers it retains all the decimals in a calculation.

If you want to round a calculated field to one decimal place you would use a format like this

Round([Hours] * [Rate],0.01)

That would, for example, round to the nearest .01 - penny)

You could also do, for example 

Round([Qty Produced] / [Minutes]),0.1)

to round to the nearest tenth.