software

I'm using the following formula in a cell:
=quot;@quot; amp; quot; quot; amp; 'Per Job Analysis'!E49 amp; quot;/Milequot;

How can I change the 'Per Job Analysis'!49 into currency format?

Right now the cell returns: quot;@ 0.7/Milequot;
I would like it to return: quot;@ $0.70/Milequot;

Thanks!

Try this:

=quot;@quot; amp; quot; quot; amp; TEXT('Per Job Analysis'!E49,quot;$0.00quot;) amp; quot;/Milequot;

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;tvhquot; wrote:

gt; I'm using the following formula in a cell:
gt; =quot;@quot; amp; quot; quot; amp; 'Per Job Analysis'!E49 amp; quot;/Milequot;
gt;
gt; How can I change the 'Per Job Analysis'!49 into currency format?
gt;
gt; Right now the cell returns: quot;@ 0.7/Milequot;
gt; I would like it to return: quot;@ $0.70/Milequot;
gt;
gt; Thanks!

Perfect! Thanks Ron...

quot;Ron Coderrequot; wrote:

gt; Try this:
gt;
gt; =quot;@quot; amp; quot; quot; amp; TEXT('Per Job Analysis'!E49,quot;$0.00quot;) amp; quot;/Milequot;
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;tvhquot; wrote:
gt;
gt; gt; I'm using the following formula in a cell:
gt; gt; =quot;@quot; amp; quot; quot; amp; 'Per Job Analysis'!E49 amp; quot;/Milequot;
gt; gt;
gt; gt; How can I change the 'Per Job Analysis'!49 into currency format?
gt; gt;
gt; gt; Right now the cell returns: quot;@ 0.7/Milequot;
gt; gt; I would like it to return: quot;@ $0.70/Milequot;
gt; gt;
gt; gt; Thanks!