Excel Format Cell As Kilowatts

[Solved] Excel Format Cell As Kilowatts | Vb - Code Explorer | yomemimo.com
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

Answers related to excel format cell as kilowatts

Code Explorer Popular Question For Vb