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 vote234 views1 answer
Excel vba StartUpPosition
VBA
3 votes296 views2 answers
Excel "vba" match last value
VBA
0 vote250 views4 answers
Vgrive,deb
VBA
4 votes238 views2 answers
Vba create folder if not exist
VBA
0 vote266 views2 answers
Get unique random number in vb.net
VBA
3 votes259 views1 answer
Vba request json
VBA
0 vote245 views1 answer
Arq linux
VBA
1 vote236 views1 answer
Excel vba saveas force overwrite
VBA
3 votes263 views1 answer
Excel vba get the workbook full filename with path
VBA
0 vote245 views1 answer
Excel vba unmerge sheet
VBA