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

4 votes199 views1 answer
Excel formula for last non-empty cell in a column
VBA
0 vote216 views1 answer
Menus act like radio buttons vb.net
VBA
0 vote201 views1 answer
Afficher un message d'erreur vba
VBA
-1 vote209 views1 answer
VBA check if a cell contains a letter or string
VBA
0 vote219 views1 answer
Vb.net change cursor to wait
VBA
0 vote208 views2 answers
How to concatenate more than 40 lines in vba
VBA
0 vote212 views1 answer
Vbs
VBA
0 vote211 views2 answers
Vb.net include quotes in string
VBA
0 vote227 views1 answer
Filesystemobject vba reference
VBA
0 vote207 views1 answer
Add text to combobox drop down vb
VBA