Hi,
I learnt that " " & can combine the text and figure. However, when it comes to a negative numbers, i dont know how to maneouver it. Could someone please enlighten me?
Eg, Cell A1 is USD(50,000.00) and
the comment in Cell B1 is Cost is USD(50,000.00).
So the function in B1 = "Cost is "& what to put here?
Thanks
Last edited by mingali; 10-14-2009 at 11:42 AM.
Hi,
How about
Rgds
Please Login or Register to view this content.
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.
Hi,
How about if i need the figures to be in formatted as _(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_) ?
Thanks
=Cost is " & TEXT(A1, "_(#,##0.00;(#,##0.00);_(""-""??;_(@")
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks