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 vote194 views1 answer
Vba get application version
VBA
20 votes264 views1 answer
Excel vba factorial
VBA
0 vote143 views1 answer
Vba code to remove leading and trailing spaces
VBA
0 vote185 views1 answer
Remove frist letter from string vbnet
VBA
0 vote242 views1 answer
Excel vba delete columns in range
VBA
8 votes249 views1 answer
Excel vba make word
VBA
0 vote185 views1 answer
Excel vba copy entire sheet paste values
VBA
0 vote204 views1 answer
Freeze panes vba
VBA
0 vote193 views1 answer
Vba like with wildcard
VBA
0 vote201 views1 answer
Not allow form to be resized
VBA