thousands comma separator in VBA

  • Thread starter Thread starter Wendy Francis
  • Start date Start date
W

Wendy Francis

Hi
I have variables defined in an Excel macro as Long, and I want them to
return the value in a Word Report with thousand comma separators - is there
a way of doing this please?
Wendy Francis
(e-mail address removed)
 
Hi Wendy

You can use FormatNumber() to format your variable before you produce
your report.

eg. YourVariable = FormatNumber(YourNum, , , , vbTrue)

Regards
Shaun
 

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

Decimal dot to Decimal Comma 3
format numbers with commas 1
Decimal Points and comma separators 2
milliones separator 1
thousand separator conversion from dot to comma 10
Merging worksheet into MS Word mail merge 6
Mail Merge - Thousand separators & Decimals 0
Mail Merge - Thousand separator and decimals 1

Back
Top