View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default 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