software

It would be helpful and space saving to be able to have a cell calculate a
formula, and then allow text before or after the answer. For example: the
cell may contain a formula that reads =sum(B1:B14) where the answer is 2.49.
I want the cell to SHOW quot;2.49 per unitquot;

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the quot;I
Agreequot; button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click quot;I Agreequot; in the message pane.

www.microsoft.com/office/comm...et.f unctions

Why not do at least some research before posting this

=SUM(B1:B14)amp;quot; per unitquot;

or=TEXT(SUM(B1:B14,quot;$#,##0.00quot;)amp;quot; per unitquot;--

Regards,

Peo Sjoblom

nwexcelsolutions.comquot;wood nerdquot; lt;wood gt; wrote in message
...
gt; It would be helpful and space saving to be able to have a cell calculate a
gt; formula, and then allow text before or after the answer. For example: the
gt; cell may contain a formula that reads =sum(B1:B14) where the answer is
gt; 2.49.
gt; I want the cell to SHOW quot;2.49 per unitquot;
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow
gt; this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt; www.microsoft.com/office/comm...et.f unctions
Good points, Peo

plus...if the number would be used for subsequent calculations:

Custom Number Format: 0.00quot; per unitquot;

(I think MS has this particular one covered)

***********
Regards,
Ron

XL2002, WinXP-Proquot;Peo Sjoblomquot; wrote:

gt; Why not do at least some research before posting this
gt;
gt; =SUM(B1:B14)amp;quot; per unitquot;
gt;
gt; or
gt;
gt;
gt; =TEXT(SUM(B1:B14,quot;$#,##0.00quot;)amp;quot; per unitquot;
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; nwexcelsolutions.com
gt;
gt;
gt; quot;wood nerdquot; lt;wood gt; wrote in message
gt; ...
gt; gt; It would be helpful and space saving to be able to have a cell calculate a
gt; gt; formula, and then allow text before or after the answer. For example: the
gt; gt; cell may contain a formula that reads =sum(B1:B14) where the answer is
gt; gt; 2.49.
gt; gt; I want the cell to SHOW quot;2.49 per unitquot;
gt; gt;
gt; gt; ----------------
gt; gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; gt; Agreequot; button in the message pane. If you do not see the button, follow
gt; gt; this
gt; gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; gt; click quot;I Agreequot; in the message pane.
gt; gt;
gt; gt; www.microsoft.com/office/comm...et.f unctions
gt;
gt;
gt;

plus, if you want to show a note in the formula bar,
but not in the cell...
=SUM(B1:B14) N(quot; calculated per unit quot;)
--
Jim Cone
San Francisco, USA
www.realezsites.com/bus/primitivesoftware
quot;Ron Coderrequot;
gt;
wrote in message
Good points, Peo

plus...if the number would be used for subsequent calculations:

Custom Number Format: 0.00quot; per unitquot;

(I think MS has this particular one covered)

***********
Regards,
Ron

XL2002, WinXP-Proquot;Peo Sjoblomquot; wrote:

gt; Why not do at least some research before posting this
gt;
gt; =SUM(B1:B14)amp;quot; per unitquot;
gt;
gt; or
gt;
gt;
gt; =TEXT(SUM(B1:B14,quot;$#,##0.00quot;)amp;quot; per unitquot;
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; nwexcelsolutions.com
gt;
gt;
gt; quot;wood nerdquot; lt;wood gt; wrote in message
gt; ...
gt; gt; It would be helpful and space saving to be able to have a cell calculate a
gt; gt; formula, and then allow text before or after the answer. For example: the
gt; gt; cell may contain a formula that reads =sum(B1:B14) where the answer is
gt; gt; 2.49.
gt; gt; I want the cell to SHOW quot;2.49 per unitquot;
gt; gt;
gt; gt; ----------------
gt; gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; gt; Agreequot; button in the message pane. If you do not see the button, follow
gt; gt; this
gt; gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; gt; click quot;I Agreequot; in the message pane.
gt; gt;
gt; gt;
www.microsoft.com/office/comm...et.f unctions
gt;
gt;
gt;