•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Are multiple text fields in a number format possible?
Our take
In Excel 2019, customizing number formats to display complex values can enhance clarity and engagement. You're aiming to represent a number like 6,050,001,000 as 6B 50M 1k, which involves multiple text fields in a single custom format. While you've successfully implemented conditional formatting to display variations, your desire to present the full string is valid. Unfortunately, Excel's custom number formatting typically limits this to a single text field, making it challenging to achieve your desired representation without additional workarounds.
Using Excel 2019, I'm trying to use a cell's custom number formatting to display, say
6,050,001,000
as
6B 50M 1k
Is this possible? I've found a way to make the format conditional, so it will display one of the three dynamically, but I'd rather show the full string if I'm able to. Results I've found seem to suggest you can only have a single text field in a custom number format rather than multiple.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel compatibility#Excel alternatives for data analysis#Excel alternatives#rows.com#Excel 2019#custom number formatting#number format#dynamic display#text field#6,050,001,000#6B 50M 1k#conditional formatting#cell format#full string display#results#formatting limitations#multiple text fields#Excel functions#user inquiry#Excel features