View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
KRK KRK is offline
external usenet poster
 
Posts: 91
Default 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