Help with custom formats pls

[KRK]

Hello

I have a number (usually 1 decimal place, sometimes an integer) which I want
to show with its units (in this case kWh), eg 3250.6 kWh.

I know I can put the kWh in the following cell, or I could turn the number
into text & append 'kWh ' on to it.

But can custom formats be used to do this (it would be far more elegant) ??

Thanks as always
KK

 

[Ron Rosenfeld]

Hello

I have a number (usually 1 decimal place, sometimes an integer) which I want
to show with its units (in this case kWh), eg 3250.6 kWh.

I know I can put the kWh in the following cell, or I could turn the number
into text & append 'kWh ' on to it.

But can custom formats be used to do this (it would be far more elegant) ??

Thanks as always
KK

Format/Cells/Number/Custom
Type: 0" kWh"

--ron

 

[KRK]

Thanks, that worked fine

KK

Format/Cells/Number/Custom
Type: 0" kWh"

--ron

 

[KRK]

Thanks, that worked fine

KK

Format/Cells/Number/Custom
Type: 0" kWh"

--ron