Pivot Table Format number

  • Thread starter Thread starter Jose
  • Start date Start date
J

Jose

I'm using an adp access 2007.
How can I format the number to2,000,000 (without decimals and with comma for
thousands)?

Thanks for any suggestion

JCP
 
Thanks Wayne,

I'm using adp access file, so the back end is SQL Server. With adp, we can't
use format(number, "#,###")

If you have any suggestion, I aprreciate

Thanks,
JCP
 
Back
Top