Customized formating

**Domyzon** · 10-28-2011, 08:40 AM

Hello!

Is this possible in excel? -->

A1=2

For example in cell A2, I would like to use the formula =A1, and I would like to add part of text there as well. So if I refer to A1 in A2 and add text part, it would appear in A2 as follows:
2 out of 10.

Is such customized formating possible?

Thanks!

Martin

**arthurbr** · 10-28-2011, 08:48 AM

Perhaps something like =A1&" Out of 10" ?

EDIT : or custom format as # "Out of 10"

**Domyzon** · 10-28-2011, 08:57 AM

okei thanks alot

The right one was:

#" out of 200"

**arthurbr** · 10-28-2011, 09:22 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save