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 vote125 views1 answer
Make all controls in an area not visable vb
VBA
1 vote77 views1 answer
Ms access open form to new record
VBA
0 vote132 views1 answer
Vba file chooser
VBA
3 votes129 views1 answer
Vba folderexists
VBA
0 vote127 views1 answer
Vbnet line graph smooth lines
VBA
1 vote139 views1 answer
Vba login website
VBA
0 vote137 views1 answer
Vba variable number of arguments
VBA
0 vote130 views1 answer
Vba find sub dictionary
VBA
0 vote126 views1 answer
Vbnet check if sting contians symbols
VBA
0 vote155 views1 answer
Search for text in every worksheet excel visual basic
VBA