vba help - Number format for blank cell want dash

[Mallesh23]

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

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

 

[Mallesh23]

Hi Rory,

Great ! Thanks for your help, it is working now. ?


Thanks
mg

 

[yky]

Hi Rory,

Custom Format. shows below formating..
_ * #,##0.00_ ;_ * -#,##0.00_ ;_ * "-"??_ ;_ @_

Thanks
mg

I tried it and it did nothing for blank cells. For cells containing zero, a dash was displayed. Am I missing something?

 

[Mallesh23]

Hi Yku,

I was looking a dash for 0 zero values.
Can we also show dash for blank cells as well.


Thanks
mg

 

[RoryA]

No, not with a number format, as I said earlier.

 

[Mallesh23]

Hi Rory,

Thanks once again for the information.


Thanks
mg