View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Inserting symbol

Hi,

Do it with a format.

Right click your cell - Format - Number tab -select Custom
enter this custom format alter to include the symbol you wannt

0.0" Your Symbol"

OK

Mike

"judyl" wrote:

I'm trying to insert a symbol next to a number in a cell that is totaled.
When I attempt this the number is not then recognized for the correct total.
Do I need to change my SUM fx in some way to correct this?