Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'd like to have the ability to enter a description within a calculation
instead of entering the description in an adjacent cell. Something like: =(4.08+2.5)[Acres] would yeild a result of 6.58 Acres. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" 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 "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Try this........
=4.08+2.5&" Acres" Vaya con Dios, Chuck, CABGx3 "silverliningboy" wrote: I'd like to have the ability to enter a description within a calculation instead of entering the description in an adjacent cell. Something like: =(4.08+2.5)[Acres] would yeild a result of 6.58 Acres. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" 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 "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
=(4.08+2.5) & " Acres"
That should do it. You coul also devise a customized format .. HTH -- AP "silverliningboy" a écrit dans le message de news: ... I'd like to have the ability to enter a description within a calculation instead of entering the description in an adjacent cell. Something like: =(4.08+2.5)[Acres] would yeild a result of 6.58 Acres. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" 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 "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Try this:
=(4.08+2.5) & " Acres" HTH, Elkar "silverliningboy" wrote: I'd like to have the ability to enter a description within a calculation instead of entering the description in an adjacent cell. Something like: =(4.08+2.5)[Acres] would yeild a result of 6.58 Acres. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" 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 "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
You may even use a custom format like:
#.#0 "Acres" That will show 6.58 Acres while the cell contains only the number 6.58 Miguel. "silverliningboy" wrote: I'd like to have the ability to enter a description within a calculation instead of entering the description in an adjacent cell. Something like: =(4.08+2.5)[Acres] would yeild a result of 6.58 Acres. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" 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 "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
missing cell borders in Excel | Excel Discussion (Misc queries) | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
resetting last cell | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) |