Thread
:
Convert a number to text and add a comma separator for thousands
View Single Post
#
3
Posted to microsoft.public.excel.programming
prahz
external usenet poster
Posts: 18
Convert a number to text and add a comma separator for thousands
Thank you!
wrote:
Hi
In VBA use
Format(rents, "#,##0")
The #,##0 is a custom number format in Excel that you can see in
Format, Cells..., Custom.
regards
Paul
prahz wrote:
I have a Text Box in a User Form that I am creating. The Text Box's
value is set to a number without decimals.
For example:
Dim rents As Long
rents = 4102
rentsTxtBox.Value = rents
So when the number passes to the Text Box, I want it to display like
this: 4,102. Basically, is there an vba function for excel that
converts a number to a string and then adds the comma separator for
thousands? If not what code would I use to do this?
Thanks.
Reply With Quote
prahz
View Public Profile
Find all posts by prahz