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 vote221 views1 answer
Type excel.application is not defined vb
VBA
0 vote218 views1 answer
How to set location and size of new from vb
VBA
0 vote246 views1 answer
Find if year is leap year vb
VBA
0 vote237 views1 answer
Write listbox to text file vb.net
VBA
1 vote225 views1 answer
Excel vba close form escape key
VBA
1 vote219 views1 answer
Vba ubound array 2-dimensional
VBA
0 vote255 views1 answer
Amd64 vs arm64 linux
VBA
0 vote221 views1 answer
Handling a click event anywhere inside a panel vb
VBA
5 votes252 views1 answer
Excel vba tool to help with refactoring code
VBA
2 votes224 views1 answer
Date format for ms chart vb.net
VBA