Hi,
A format can't add anything to a cell it can only display it in a different way.
You can obviously do it with a third cell
=A2&" (£"&TEXT(A1*A2,"0.00")&")"
Hi,
A format can't add anything to a cell it can only display it in a different way.
You can obviously do it with a third cell
=A2&" (£"&TEXT(A1*A2,"0.00")&")"
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks