•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?
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]
Want to read more?
Check out the full article on the original site
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