Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert a number to text and add a comma separator for thousands
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert a number to text and add a comma separator for thousands
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert a number to text and add a comma separator for thousands
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number Format: Convert No. to thousands | Excel Discussion (Misc queries) | |||
separator of thousands | Excel Discussion (Misc queries) | |||
thousands comma separator in VBA | Excel Discussion (Misc queries) | |||
separator of thousands | Excel Discussion (Misc queries) | |||
comma s separator text file | Excel Programming |