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 vote239 views1 answer
Vbs run with cscript
VBA
0 vote231 views1 answer
Excel delete ever other vba
VBA
0 vote243 views1 answer
Delete all controls in an area vb
VBA
6 votes237 views1 answer
Excel vba check if a string only contains alpha characters
VBA
1 vote238 views1 answer
Set font for ms chart vb.net
VBA
8 votes249 views1 answer
Excel vba make integer
VBA
0 vote249 views1 answer
Excel vba ternary
VBA
0 vote215 views1 answer
Excel vba disable copy paste
VBA
0 vote216 views1 answer
Hello world vb.net
VBA
0 vote226 views1 answer
Vbs
VBA