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

1 vote209 views1 answer
Excel vba Populating a combobox on a userform from a range of cells
VBA
0 vote226 views1 answer
How to format a textbox as date vb net
VBA
1 vote208 views2 answers
Get all column names from excel vba
VBA
0 vote228 views1 answer
Vba simple quote
VBA
0 vote225 views1 answer
Loop through lines in text file vb net
VBA
0 vote228 views1 answer
(SecurityProtocolType)3072 vb.net
VBA
0 vote223 views1 answer
Nested if else in vb.net
VBA
0 vote229 views1 answer
Reference to a non-shared member requires an object reference
VBA
2 votes244 views2 answers
Excel vba if sunday or staurday
VBA
0 vote256 views1 answer
Vbnet check if string is only numbers
VBA