Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel numerical value in a cell
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel numerical value in a cell
Resolved · Urgent Priority · Version 2003
Reply Thu 15 Apr 2010, 15:45Delegate Cherry said...
Cherry has attended:
Excel Intermediate course
Excel Advanced course
Excel numerical value in a cell
Hi,
Please could you help with the following enquiry? Is there any way of adding a numerical integer into a cell that already contains a different number. For example in A1, it shows 12, A2 shows 12, A3 shows 8 can you make each cell mean 10 so that when you use the formula =sum(a1+a2+a3) it adds up to 30?
Many thanks
Cherry
For upcoming training course dates see: Pricing & availability
RE: Excel numerical value in a cell
Hi Cherry, thanks for your query. There is no standard function in Excel to allow you to do this and to achieve it would involve some bespoke VBA. However, depending on what you want to achieve, have you thought about have 10 as the value in A3 and then drawing a white-filled rectangle over the cell with the number 8 in it, obscuring the real value but leaving it intact for use in formulae? The end result, visually at least, would be the same as your request.
Hope this helps,
Anthony
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
Thu 22 Apr 2010: Automatically marked as resolved.
|