Forum Discussion
Space as thousand seperator using Format()
Hi,
I need to use a space as thousand seperator in my format function:
In this example i used ',' as a seperator and everything is fine:
when I change the ',' with a ' ' (space) you see the formatted text is all messed up.
any idea?
Anonymous , In case comma, it does it automatically
try
"### ### ###.##"
4 Replies
- amitchandak
Super User
Anonymous , Try like
"# ###.##"
Hi amitchandak ,
as you can see below, when the number > 1M , it doesn't show the seperator with your solution.
- amitchandak
Anonymous , In case comma, it does it automatically
try
"### ### ###.##"