Question : excel format cell as kilowatts
Answered by : daniel-ferry
'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 : http://academy.excelhero.com/ | Last Update : Fri, 08 May 20