Hi all
I have the value 4.5 in A1 cell formatted to currency so displays the column contents as $4.50.
In another column I want to display a line of of text with this price displayed inside it. ="($Todays price is:"&A1&"etc etc) , however displays as 'Todays price is $4.5 ' How can I get it to add a 0 where needed? Thanks for the help.
Microsoft excel for Mac 2011 14.6.5
Last edited by dcurran; 07-11-2016 at 07:10 AM. Reason: Additional info
try using
="Todays price is: "&TEXT(A1,"$#,###.##")&" etc etc"
https://support.office.com/en-gb/art...8-93d29371225c
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Maybe =("Today's price is"&" $ "&A1 & 0) because it is a string
Edit: I like Wayne's solution better, however.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Hi,
I would note that you need 0 rather than # for missing 0s in the display:
="Todays price is: "&TEXT(A1,"$#,##0.00")&" etc etc"
whoops - thanks - had that before edit and change to add the '#####' and left the 0.00
thanks for the correction
Great solution thanks. End result worked like a treat : ="1-24 ("&TEXT(A1,"$0.00")&");25-49 ("&TEXT(A2,"$0.00")&");50-99 ("&TEXT(A3,"$0.00")&");100-249 ("&TEXT(A4,"$0.00")&");"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks