Excel: underline $###,###.##

[mtdew]

I have a formula which reads:

=" (3) The cash sales price of the leased property is "&TEXT(L19,"$###,###.##")

How can I have the $###,###.## underlined? I have tried the obvious ways of selecting but the underline feature is grayed out and if I highlight and right click format is not an option. Any way to do it?

 

[AnotherHiggins]

A formula cannot impart formatting - it only returns a value.

And, as you've seen, Excel doesn't support manually formatting a single cell two different ways when that cell contains a formula.

You can:[ol]
[li]Copy and Paste Special > Values to get rid of the formula, then manually underline part of the cell contents[/li]
[li]Split the formula into two cells and format the cells differently (you could take steps to make it look like the data was in a single cell)[/li]
[li]Use VBA to do option 1 for you - the cell still wouldn't contain a formula, but you wouldn't have to manually format anything. And you could set up a macro to update the number portion of the cell when the sheet is updated, simulating the effect of having a dynamic formula[/li]
[li]Not underline the number portion of your formula [/li]
[/ol]


[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.