'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"""