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

On Tue, 12 Jan 2010 12:26:58 -0000, "KRK"
wrote:

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

Thanks, that worked fine

KK


"Ron Rosenfeld" wrote in message
...
On Tue, 12 Jan 2010 12:26:58 -0000, "KRK"
wrote:

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

Thanks, that worked fine

KK


"Ron Rosenfeld" wrote in message
...
On Tue, 12 Jan 2010 12:26:58 -0000, "KRK"
wrote:

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