Can an Excel cell copy its format across to another cell when using the =& functions?

Hi, you could format the cell in A22 and place a checkmark in the "Use 1000 Separator (,)"

1. Right-click on cell A22

2. Go to Format Cells

3. Choose "Number" from the Category List

4. Checkmark "Use 1000 Separator (,)"

5. Click OK

Hope that is what you wanted.

Before I offer my suggestion, I just want to say I laughed out loud when I read Thomas Bk's response - 'cos mine was the same, the first time I read your question!

I can't think of any way to do what you want 'cos you're trying to instruct one cell to have two types of formatting.

Have you considered splitting the contents between two columns (if you have no line between them, they won't look much different) - i.e. in cell A22, you have the 'last yr she made' bit - and in cell B22, you just have =B22

That way, you can format the text as text and the number as 'Accounting' with comma thousands separator.

i think of and nonetheless uncertain; i comprehend it may no longer’t be A. insert functionality by using fact all of us comprehend replica and paste is greater probable would be an Edit classification-no longer an insert functionality. B. custom lists is greater probable to establish your formats. C. conditional formatting is in basic terms that-greater probable for columns. i think of “earthdrivenforce” gave you the properly suited answer. It sounds like he knew what he's speaking approximately. by using fact in Excel shrink and paste is interior the device section, i think of it may be D. “Use the fill device”. i'm hoping it’s no longer your try. If it in basic terms your homework, that is extremely helpful to deliver IM or digital mail to invite your Professor. Sorry i'm uncertain.

first made B22 as text formatted..

Then use the formula

="Last year she made $"&TEXT(B22,"#,###")

An alternative to "#,###" is "#,###.00" which will include cents