Posted to microsoft.public.excel.worksheet.functions

tvh

Posts: n/a

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!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Format Currency	Send Object Command - Two attachments	Excel Discussion (Misc queries)	1	November 10th 05 04:44 PM
Cond. Format & Absolute Cell Reference Question	nastech	Excel Discussion (Misc queries)	4	November 9th 05 05:02 PM
Incorrect Currency Displayed	Maxy	Excel Discussion (Misc queries)	4	November 9th 05 03:20 PM
protecting format	Esmerelda	Excel Discussion (Misc queries)	1	February 25th 05 12:53 PM
convert a numerical currency into word format	Rojo	Excel Worksheet Functions	1	February 24th 05 11:31 PM

All times are GMT +1. The time now is 11:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us