By using this website, you agree to our Terms of Use (click here)
Notifications
Clear all
June 4, 2017 9:55 pm
Hi Everyone,
I'm trying to make my Pivot Table columns smaller because I have a lot of columns and I'm running out of space.
I don't really need the decimals to be displayed on my numbers.
Does anyone know if I can format my numbers to show whole dollars without the decimals?
2 Replies
June 4, 2017 10:00 pm
Hi Piggy,
Yes, you can do this. Just highlight the field that you want to format and put #,### in the Format field. If you wanted to include the decimals, the format code would be #,###.00
Acumatica Version 6.10.0472 used when composing this response
June 4, 2017 10:01 pm
Hey, that was easier than I thought it would be. Actually, I was worried that it couldn't be done. This is great, thanks!