Hi Team,
Need your help in applying format, if there are blank add dash.
Below attempted code which only covers positive and negative nos. not blank cells
Below is a table with expected output in Column C.
Thanks
mg
Need your help in applying format, if there are blank add dash.
Below attempted code which only covers positive and negative nos. not blank cells
VBA Code:
Sub test()
Range("A2:A6").NumberFormat = "#,#.00"
End Sub
Below is a table with expected output in Column C.
Book10 | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Raw Data | Expected | |||
2 | 5000 | 5,000.00 | |||
3 | 100 | 100.00 | |||
4 | -4000 | -4,000.00 | |||
5 | - | ||||
6 | 18000 | 18,000.00 | |||
Sheet1 |
Thanks
mg