Formatting

[Waikato300zxClub]

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.

 

[Guest]

There are two methods of using these special symbols:

First one is using Character Map from the System Tools and then copying and
pasting specialy symbols as desire.

The easiest method is using shortcut key:

For example, when you want to use type degree sign for 10oc
press ALT+0176 key like this 10°c
press ALT+0177 key like ±

Hope this will help. Let us know.

 

[Waikato300zxClub]

Hi thanks for that, it has shown me something new and nifty in excel I
didnt know before, and it works well.

Thanks alot,

Slash.