Hi,
How would I remove the decimal places when concatenating?
To be more specific, i want to set the number to two decimal places.
Thanks
ResulG
Hi,
How would I remove the decimal places when concatenating?
To be more specific, i want to set the number to two decimal places.
Thanks
ResulG
Hi,
If I understand corrrectly,
use your concatenate after left(),mid() and right() functions to avoid decimals separator ...
HTH
Carim
![]()
or *100Originally Posted by Carim
---
Si fractum non sit, noli id reficere.
Bryan ...
Why make it simple ...
when you can make it difficult ... !!! lol ...
Well done much smarter ...![]()
![]()
![]()
Cheers
Carim
![]()
Yes but this number will change and I dont think this suggestion will do the work.
I tried (A1,"0.00") but to no avail.
just something I spotted a while ago, I guess what may really be sought is something likeOriginally Posted by Carim
=Text(A1,"#.00")
or some variation, but we can only answer the question as we believe it was asked.
---
(master of mis-interpretation)
Sorry guys, but this sisnt as simple as you put it.
The text displays this:
100 Netherland NLG = 7550.26750343739 Spain ESP
The formula is this:
=CONCATENATE(D9," ",H9," ",I9," ","="," ",D13," ",H12," ",I12)
Something that should be done to D13 so I get 7550.26.
ResulG
Done it guys..
Heres the solution
=CONCATENATE(D9," ",H9," ",I9," ","="," ",TEXT(D13,"0.00")," ",H12," ",I12)
Thanks
ResulG
Good to see, and thanks for the response.Originally Posted by ResulG
---
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks