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 vote191 views1 answer
Weekday vba
VBA
0 vote176 views1 answer
Vbnet line graph smooth lines
VBA
0 vote185 views1 answer
Excel vba calculate
VBA
15 votes412 views2 answers
Xl vba dynamic string array
VBA
0 vote196 views1 answer
Selecttoken em vbnet e json
VBA
0 vote173 views1 answer
Change "location" of binding navigator vb
VBA
4 votes176 views1 answer
Excel formula for last non-empty cell in a column
VBA
0 vote183 views1 answer
How to format a textbox as date vb net
VBA
1 vote186 views1 answer
How to put a gridpain in a vbox
VBA
3 votes194 views1 answer
Vba http request json
VBA