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 vote335 views1 answer
Vb get ip address
VBA
0 vote332 views1 answer
Vbnet line chart showing extra space
VBA
1 vote385 views1 answer
Vba login website
VBA
1 vote313 views1 answer
Excel vba hide zero values
VBA
0 vote330 views1 answer
Vba border weight
VBA
0 vote370 views1 answer
Excel vba set cell value to empty
VBA
0 vote322 views1 answer
Discern between file and folder given path vb.net
VBA
0 vote349 views1 answer
Vba listbox remove all items
VBA
0 vote334 views1 answer
Excel vba saveas no prompt for overwrite
VBA
0 vote346 views1 answer
Excel vba send HTTP POST to server
VBA