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 vote138 views1 answer
Regex numeric digits
VBA
0 vote134 views1 answer
Dlete rows with blanks and space " " vba
VBA
0 vote122 views1 answer
Vlookup columns not next to each other
VBA
5 votes148 views1 answer
Excel vba get low byte from INTEGER
VBA
0 vote127 views1 answer
Reference to a non-shared member requires an object reference
VBA
5 votes140 views1 answer
Excel vba low word from Long Integer
VBA
0 vote134 views1 answer
Arq linux
VBA
5 votes131 views1 answer
Xl vba double quotes in string literal
VBA
0 vote127 views1 answer
How to carry text to the next line in a label in vb.net
VBA
0 vote193 views1 answer
Find the name of the last excel sheet vb
VBA