Format the same cell with two different formats.

[GeorgeCunn]

The first number in the cell should be a number (without decimals and the second number should be currency including the cents. An example of what I am trying to achieve is: 5,000 $15.00. The entry in the cell would be 5000 followed by a space and then 15. I tried formatting in Custom Format with: ##,#0 &" " $#,##0 This didn't work. Any suggestions? Thank you.

 

[JLGWhiz]

A cell can have only one number format. To do what you are trying to do, the entries would have to be text and be concatenated.
Example

Discussions.xlsm
	A	B	C	D	E
1
2	5000	$15.00		5000 $15
3
4
Sheet1

Cell Formulas
Range	Formula
D2	D2	=A2&" "&"$" &B2

 

[mole999]

got to say try and push it to two columns

 

[joeu2004]

The first number in the cell should be a number (without decimals and the second number should be currency including the cents. An example of what I am trying to achieve is: 5,000 $15.00. The entry in the cell would be 5000 followed by a space and then 15.

More importantly, a cell can have only one numeric value. And numeric formats work only for numeric values.

On the contrary, what you describe is a text value. To demonstrate, confirm that =ISTEXT(A1) returns TRUE, if A1 is the cell with the data "5000 15".

AFAIK, there is no text format option to change the appearance of text values.

You would need to enter a formula in another cell. For example:

Book1
	A	B
1	5000 15	5,000 $15.00
Sheet1

The formula in B1 is:

=TEXT(LEFT(A1, FIND(" ",A1)-1), "#,##0 ") & TEXT(MID(A1, FIND(" ",A1)+1, 99), "$#,##0.00")

That presumes that the form of the text in A1 is exactly as you stated, specifically: there is only one normal space between two strings that Excel would recognize as a number.

PS.... IMHO, it is a bad idea to have two "numbers" (text) in one cell. Consider using the Text To Column feature to separate a column of such data into two separate columns.