Formatting Problem

[bw]

I have a concatenated formula in cell A1 (contains both text and numbers).
I am trying to format the cell, right justified, with spaces to the right of
the value displayed.

I have been successful by formatting the cell as @" ".

However, when I format the cell in this manner, I can no longer modify the
formula and have it entered as a formula. When I remove the formatting, I
can then modify the formula which now is a working formula, and then format
it again as above.

This of course seems very strange, so I must be doing something wrong by
formatting with @" ".

Does anyone have a suggestion how to accomplish what I'm trying to do here?

Thanks,
Bernie

 

[JE McGimpsey]

XL will default to a Text format for your cell, so when you modify your
formula, it's interpreted as text. When you remove the format (go back
to General, the formula can be entered and the format then reapplied.

You can do this all within the formula itself:

=TEXT(<your formula here>,"@"" """)

 

[Mladen_Dj]

I'm not sure I was understand what you trying to do, why you don't use
formula:

=a1&" "&B1

and general number format?

Can you give example of your formula syntax, also , do result of your
formula is suppose to be NUMBER TEXT, or TEXT NUMBER.

 

[Vince]

I'm not sure I was understand what you trying to do, why you don't use
formula:

=a1&" "&B1

and general number format?

This file has nothing to do with formula(s)

Its straight data.

 

[bw]

I see that my response was not posted. I probably sent it directly to Mr.
McGimpsey as I sometimes do. Sorry about that!

Thank you sir! Your answer is what I was looking for.

Bernie