Merge Cells

[texcel]

I want to display the PERCENTS from 3 different cells in ONE CELL WITHOUT THE % SIGN.

Example:

A1: 45%
A2: 37%
A3: 18%

A4: 45/37/18

[oldchippy]

Try this,

=A1*100&"/"&A2*100&"/"&A3*100

[texcel]

That didnt work...

I think its because..

To get the percent values I did some math inside the cell

and then..

Formatted the cell to be a percent

***********

Example

To get 45% in A1...

I divided 108 by 240

and then formatted the cell for a percent

[oldchippy]

Can't understand why that doesn't work, it's works fine here????

[texcel]

Maybe my spreadsheet just sucks...


Could you try this...

In cell A1 divide 156/350 = .4457

Format A1 to a percent with no decimals = 45%

Than use your formula to add the 45% with the other values

[oldchippy]

Yes, that changes things a bit - see attached

[texcel]

Genius!

Thank You Sir

[oldchippy]

Glad to help - thanks for the feedback

[texcel]

How do I add an image for myself like you have...the dwarf?

[oldchippy]

For some reason?, only when you become a Moderator can you post a Avatar

[texcel]

How do I mark this thread SOLVED

[oldchippy]

Exactly like you've just done it - thanks