numeric formatting limit digits

If you were just concerned about how it displays, then you could set the field properties as to how many decimals to display. But you also said "export to excel" - so you will need to change your actual formula to round.



For the formula which has the percentage, try this

Round(

..then keep your formula here

,0.0001)



For the formula which has the $ amount, try this

Round(

..then keep your formula here

,0.01)

that is great.  what if I didn't want to round but just wanted to show/export those decimal places...which would I use?

that is great.  what if I didn't want to round but just wanted to show/export those decimal places...which would I use?

If you want to change how it displays in Quickbase, but still want to preserve all the decimals for exports! then don't do that around formula at all.  Just change the Field properties to set the number of digits for rounding for presentation purposes on forms and reports.

I actually want to export without the decimals also.  Is there something like round that can be used?

I'm confused by this last comment.  I gave the formula in my original answer of how to set the rounding for export.  I must not be understanding your latest comment.

sorry for the confusion.  So, yes the rounding works.  However my question is this:  I have a number: $2.5567.  I do NOT want to round but I want to display and export it as $2.55 (so it is not automatically rounding up to $2.56 but just displaying & exporting the first two decimal places). I also have a percentage 30.5555%, I want to display & export to excel as 30% (again not rounding up to 31%), Is that possible to show the number like that without rounding?