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 vote297 views1 answer
Excel PasteSpecial Format:= can't find the argument
VBA
1 vote323 views1 answer
Vba format string as cash
VBA
4 votes308 views1 answer
Excel vba Imitating the "IN" operator from python
VBA
0 vote335 views1 answer
Excel delete ever other vba
VBA
0 vote323 views1 answer
Vbs exec hidden
VBA
0 vote308 views1 answer
Vbscript Trim
VBA
-1 vote294 views1 answer
Text to speech vb.net
VBA
1 vote327 views1 answer
How to remove zeros in excel
VBA
31 votes449 views1 answer
Excel vba function to convert column number to letter
VBA
0 vote311 views1 answer
Vba code for cutoff time
VBA