Help with custom formats pls
 

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

Help with custom formats pls
 

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

Help with custom formats pls --- Thanks
 

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

Help with custom formats pls --- Thanks
 

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