OldSwimmer1650
New Member
- Joined
- Dec 3, 2020
- Messages
- 35
- Office Version
- 365
- Platform
- Windows
I'm trying align the decimal points of these two numbers. The problem is when one is negative and the other positive they don't align. I would also like not to show leading zeros.
This is for a stock picking game for a finance class.
My expression is:
=CONCATENATE(XLOOKUP(MAX(Stocks!J17:J27),Stocks!J17:J27,CurrentStocks,,0)," ",TEXT(MAX(Stocks!J17:J27),"$0,000,000.00"))
(note: The expression is the same for both Winner & Looser except Min used for Looser and Max used for Winner)
I've also tried:
=CONCATENATE(XLOOKUP(MAX(Stocks!J17:J27),Stocks!J17:J27,CurrentStocks,,0)," ",TEXT( MAX(Stocks!J17:J27),"$#,000.00"))
(note: The expression is the same for both Winner & Looser except Min used for Looser and Max used for Winner)
This is for a stock picking game for a finance class.
My expression is:
=CONCATENATE(XLOOKUP(MAX(Stocks!J17:J27),Stocks!J17:J27,CurrentStocks,,0)," ",TEXT(MAX(Stocks!J17:J27),"$0,000,000.00"))
(note: The expression is the same for both Winner & Looser except Min used for Looser and Max used for Winner)
I've also tried:
=CONCATENATE(XLOOKUP(MAX(Stocks!J17:J27),Stocks!J17:J27,CurrentStocks,,0)," ",TEXT( MAX(Stocks!J17:J27),"$#,000.00"))
(note: The expression is the same for both Winner & Looser except Min used for Looser and Max used for Winner)