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 vote217 views1 answer
Thread sleep vb
VBA
2 votes209 views1 answer
Excel vba check if string entirely numeric
VBA
3 votes209 views1 answer
Vba make long from two words
VBA
0 vote197 views1 answer
How to extract a file from an ISO:
VBA
0 vote143 views1 answer
Vba select file in folder
VBA
0 vote233 views1 answer
How to enter Vbox manage commands
VBA
0 vote213 views2 answers
Do until loop vba
VBA
1 vote219 views1 answer
Sort using vba
VBA
0 vote193 views1 answer
Do until vb.net
VBA
0 vote208 views1 answer
Convert number to minutes in vba
VBA