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 vote220 views1 answer
Vba range clear formatting
VBA
0 vote214 views1 answer
Search in richtextbox vb.net
VBA
5 votes220 views1 answer
Excel-vba get integer high byte
VBA
0 vote208 views1 answer
VBA Loop to range
VBA
0 vote218 views1 answer
Delete rows in excel vba code
VBA
0 vote203 views1 answer
Priavte sub with multiple handels find sneder
VBA
0 vote209 views2 answers
Excel vba protect cells with formula
VBA
1 vote188 views1 answer
Vba Remove Case Sensitivity
VBA
0 vote208 views1 answer
Excel vba scroll to cell
VBA
0 vote194 views1 answer
Add Formula to Shape Text in VBA
VBA