If you have 40 in a cell, you can format that cell as currency using Format/
Cells/ Number/ Currecy, & pick an appropriate option, or use a custom format
such as $0. Alternatively you can take Pete's suggestion of using the TEXT
function in another cell, such as =TEXT(A1,"$0")

Similarly if you have 0.125 you can format it as percentage using Format/
Cells/ Number/ Percentage, & pick an option. Alternatively =TEXT(A1,"0.0%")
--
David Biddulph

wrote in message
ps.com...
On Oct 26, 9:33 am, Pete_UK wrote:
The only function that can affect the formatting in this way is TEXT,
but that turns your numbers into text at the same time, which you
might not want if you do further calculations on them.

Hope this helps.

Pete


It would do if I could use some function at the same time within the
same formula
to add symbol to that texted number to get e.g. $40 or 12.5% in one
cell.
yaro