This formula was provided to me by daddylonglegs (thank you!). However, it returns a text reference. How would it be amended to return a currency?
Please Login or Register to view this content.
Attached is my sample worksheet. This formula is on the Event Flyer worksheet cell E4. I would like it to return $750.00 and not 750. I've tried every which way but the correct way, and I'm crying "uncle." Thank you for your help.
Last edited by madaboutgolf; 10-28-2011 at 02:26 AM.
put in text like so.
Please Login or Register to view this content.
Please acknowledge the response you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
Works perfectly now. Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks