Crazy custom cell formatting question.

[prostreet]

Just for Curiosity only. I have attempting to customize a cell. Lets assume it has a value of 1,234,567,890

Can you combine custom formatting to show in that cell

1 Billion, 234 Million, 567 Thousand, 890 Dollars?

I have absolutely NO use for this. It's gust something that I have been playing with.

Asking all the Excel experts that know what their doing.

Any and all answers would be appreciated.

And maybe help an 82 year old sleep better, LOL.

Thank you.

Jerome

 

[lrobbo314]

Excel
	N
32	1,234,567,890
33	1 billion 234 million 567 thousand 890 Dollars
Sheet5

Cell Formulas
Range	Formula
N33	N33	=N32

# \billio\n ### \millio\n ### t\hou\s\a\n\d ### \Doll\a\r\s

 

[prostreet]

Excel
	N
32	1,234,567,890
33	1 billion 234 million 567 thousand 890 Dollars
Sheet5

Cell Formulas
Range	Formula
N33	N33	=N32

# \billio\n ### \millio\n ### t\hou\s\a\n\d ### \Doll\a\r\s

Works perfect! Really appreciate the help.
If not opposing on you too much, could you give me a brief description of the format data.
\n \s \a \d \r ?????

 

[lrobbo314]

The '\' is an escape character. It precedes a character that has a built in format. 'h' on its own would format a number as an hour. 's' for seconds and so on. Putting the '\' in front of it lets Excel know just to put the letter in there and ignore the pre-defined format.