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 vote188 views1 answer
Excel vba formatconditions positive
VBA
0 vote183 views2 answers
Excel vba number format file size
VBA
7 votes193 views1 answer
Excerl vba array to range
VBA
1 vote179 views1 answer
Excel vba How to determine if a date falls on the weekend?
VBA
0 vote194 views1 answer
Vba search string position
VBA
0 vote188 views1 answer
Vbs run with cscript
VBA
0 vote219 views1 answer
Visual basic run command
VBA
0 vote204 views2 answers
Get unique random number in vb.net
VBA
3 votes184 views1 answer
Vba double quote
VBA
0 vote175 views1 answer
Excel PasteSpecial Format:= can't find the argument
VBA