Thread: Formatting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Formatting

Hi,

How can I make this happen.

A1=10oC
A2=+/-
A3=1oC

Z1 cell contains the formula: A1&A2&A3 and displays: 100C+/-10C

I want the superscript of the degrees in cell A1 to be in Z1 but I dont
know the text=() format to achieve this.

Thanks in advance,

Slash.