Excel format cell as kilowatts

'Excel custom Number Format for kilowatts:

[>=1000]#,##0.0" kW";[<1000]0.0" kW"

'To use this number format from VBA:

[A1].NumberFormat = "[>=1000]#,##0.0"" kW"";[<1000]0.0"" kW"""

Source: academy.excelhero.com

Similar codes

0 vote264 views1 answer
Send text to clipboard vb.net
VBA
0 vote238 views1 answer
String contins in vba
VBA
3 votes316 views1 answer
Excel vba make long from two shorts
VBA
0 vote231 views1 answer
System.InvalidOperationException: 'Row associated with the currency manager's position cannot be made invisible.
VBA
0 vote226 views1 answer
How to self delete a vbscript file
VBA
0 vote232 views1 answer
Vbscript abs
VBA
0 vote268 views1 answer
Vba DisplayGridlines
VBA
0 vote240 views1 answer
Menus act like radio buttons vb.net
VBA
3 votes254 views1 answer
Excel insert blank row for value change in column
VBA
0 vote272 views1 answer
Vba ternary
VBA