FormulaQuestioner

It sounds like you would like to select from a list what you want the
formating to be? I know of no way of doing that, maybe with vba. Normally
one would have to format a cell or group of cells through the custom
formating window as you did earlier. If my assumption is not correct post
back with a little more explaination.

Hope this helps

Mike Rogers



"FormulaQuestioner" wrote:

The Custom Cell thing worked really well.

Is there a way I can make one where it will have "Words" cell refernce "more
words" different cell refference?

"Mike Rogers" wrote:

FormulaQuestioner

There is a couple of ways that I would approach something like this:

1) I could do a custom format on the destination cell such as Format
cellcustom select 0.00, now place your curser BEFORE the first zero and
type "The price of that is ", be sure to include the quotes. Then in the
cell you just formated enter =A1 (or what ever cell has the number in it.)

2) You could put "The price of that is" in a cell off somewhere that does
not matter and reference that cell by concatenating. =Concatenate(A1,B1)

I hope this helps

Mike Rogers


"FormulaQuestioner" wrote:

Nope. I just typed this message and posted it. i did not know I was doing
anything to make it stay at the head of the list.

"Don Guillett" wrote:

Perhaps you should set your clock or did you intend to stay at the head of
the list. I delete those automatically.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"FormulaQuestioner" wrote in
message ...
I am currently working on a chart that I need to put the contents of
multiple
cells into 1. I have a few issues.

On the chart where the info is placed I have a price $2.50. I want when I
transfer the contents to other cell that is setup with code ="The Price of
that is "&CellwithPrice I have it being put in as "The Price of that is
2.5"

I would also like some cells that are 2 lines. I know if I type then
Alt-Enter it will make me type on a second line. Can I do that when it
comes
to formulas I am entering.