View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default How do I insert a pound sign infront of different values in cells

Select the cells in question and format them as currency choosing the pound
symbol from the currency list!

Regards,
Stefi


€˛tintintravels€¯ ezt Ć*rta:

Excel 2003 - Ihave mulitple cells with different values in them and want to
insert a pound sign infrontof each value. I can do this one by one but is
there a quick way to insert a pound sign in multiple cells without a) doing
each cell one at a time and b) without deleting the values in each cell?

Thank