Formatting of figures

Posted by vijay on January 28, 2002 11:57 PM

I want to format the values as below.
1 as 1
12 as 12
123 as 123
1234 as 1,234
12345 as 12,345
123456 as 1,23,456
1234567 as 12,34,567
12345678 as 1,12,45,678
123456789 as 12,34,56,789
Please help

Posted by Jon Scorey on January 30, 2002 7:57 AM

create a custom format of #,###,###

It show do exactly what you want.

Jon Scorey