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 vote158 views1 answer
Dlete rows with blanks and space " " vba
VBA
0 vote155 views1 answer
.net dark title bar
VBA
0 vote150 views1 answer
Selecttoken em vbnet e json
VBA
8 votes171 views1 answer
Run command pormpt in background windows
VBA
1 vote142 views1 answer
Excel vba get ordinal number from cardinal number
VBA
0 vote152 views1 answer
Menus act like radio buttons vb.net
VBA
0 vote171 views1 answer
Excel vba protect shapes
VBA
0 vote163 views2 answers
Open url from vba
VBA
0 vote154 views1 answer
Excel vba unmerge sheet
VBA
0 vote165 views2 answers
S yyyy-MM-dd em vb net
VBA