Mina_Minic
New Member
- Joined
- Jan 27, 2020
- Messages
- 2
- Office Version
- 2007
- Platform
- Windows
I'm trying to call up a dollar value from another sheet to my quote sheet.
I want the cell to have text followed by the amount. Example "cost of the dark scheme is $1,234"
My current formula works as far as to bring up the value, but not in currency format.
This is what I have now:
="cost of the dark scheme is" &'sheet2!G10
It works but the outcome has no currency formatting even though the cell that it is calling it up from is correctly formatted; it just spits out a number rounded to 3 decimal places and no dollar sign.
Can anyone help please?
I want the cell to have text followed by the amount. Example "cost of the dark scheme is $1,234"
My current formula works as far as to bring up the value, but not in currency format.
This is what I have now:
="cost of the dark scheme is" &'sheet2!G10
It works but the outcome has no currency formatting even though the cell that it is calling it up from is correctly formatted; it just spits out a number rounded to 3 decimal places and no dollar sign.
Can anyone help please?