numbering format
Posted: Sun Sep 12, 2021 5:30 pm
Hi Dear,
I need your help how to custom format.for example if I input 123 in cell A1 it would become ***123.00***.if i input 123000 in cell A2 it would be ***123,000.00***.
I try "***"#,###.00"***" but I have no luck.
I can format only "***"#,###.00 it would be **123.00,***123,000.00
Best Wishes,
I need your help how to custom format.for example if I input 123 in cell A1 it would become ***123.00***.if i input 123000 in cell A2 it would be ***123,000.00***.
I try "***"#,###.00"***" but I have no luck.
I can format only "***"#,###.00 it would be **123.00,***123,000.00
Best Wishes,
You can use this format,