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 vote308 views1 answer
Vba variable number of arguments
VBA
0 vote272 views1 answer
Vbnet add new ecel sheet
VBA
0 vote331 views1 answer
Vba foreach 2d array
VBA
0 vote305 views1 answer
Vba sort the data Z to A
VBA
0 vote309 views1 answer
Excel vba urlmon
VBA
0 vote311 views1 answer
Excel vba protect shapes
VBA
0 vote305 views1 answer
Rotate image by any angle vb.net
VBA
0 vote292 views1 answer
Worksheet.pastespecial textbox
VBA
0 vote292 views1 answer
Vba loop through textboxes
VBA
0 vote307 views1 answer
Vbscript remove spaces from string
VBA