ExcelBanter - Currency format within an equation...

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Currency format within an equation... (https://www.excelbanter.com/excel-worksheet-functions/65135-currency-format-within-equation.html)

tvh

Currency format within an equation...

I'm using the following formula in a cell:
="@" & " " & 'Per Job Analysis'!E49 & "/Mile"

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

Right now the cell returns: "@ 0.7/Mile"
I would like it to return: "@ $0.70/Mile"

Thanks!

Ron Coderre

Currency format within an equation...

Try this:

="@" & " " & TEXT('Per Job Analysis'!E49,"$0.00") & "/Mile"

Does that help?

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

XL2002, WinXP-Pro

"tvh" wrote:

I'm using the following formula in a cell:
="@" & " " & 'Per Job Analysis'!E49 & "/Mile"

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

Right now the cell returns: "@ 0.7/Mile"
I would like it to return: "@ $0.70/Mile"

Thanks!

tvh

Currency format within an equation...

Perfect! Thanks Ron...

"Ron Coderre" wrote:

Try this:

="@" & " " & TEXT('Per Job Analysis'!E49,"$0.00") & "/Mile"

Does that help?

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

XL2002, WinXP-Pro

"tvh" wrote:

I'm using the following formula in a cell:
="@" & " " & 'Per Job Analysis'!E49 & "/Mile"

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

Right now the cell returns: "@ 0.7/Mile"
I would like it to return: "@ $0.70/Mile"

Thanks!

All times are GMT +1. The time now is 09:35 AM.