Re: display a number in another cell

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Unless you just want to clear the other column, A bit of clarification is needed.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@xxxxxxxxxxxxx
"Motherlulu" <motherlullu@xxxxxxxxxx> wrote in message news:49c63007df3b460e921853e42a6fcb7c@xxxxxxxxxxxxxx
Hello,

I would like the number that is displayed in row M15:L15 to display in row
M15. Only one cell would have a number in it.

Thanks for your help

.



Relevant Pages

  • Re: unwanted: Zoom adjust when adjusting Print Scale
    ... Don Guillett ... Microsoft MVP Excel ... "skiing" wrote in message ... Your email address does not display ...
    (microsoft.public.excel)
  • Re: Change font color automatically
    ... Right click sheet tab>view code>copy/paste the macro. ... Don Guillett ... Microsoft MVP Excel ... > will display in black. ...
    (microsoft.public.excel.misc)
  • Re: Displaying highlighted cells sum
    ... "Don Guillett" wrote: ... Microsoft MVP Excel ... I'm trying to get my Excel 2003 to display the sum ... but I can't get my home computer to do this. ...
    (microsoft.public.excel.misc)
  • Re: NESTED IF FORMULA - IGNORE BLANK CELLS
    ... Don Guillett ... Microsoft MVP Excel ... "Evan" wrote in message ... that will look at the last non-blank cell and display the value. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: with formulas that show negative results I want to show zero i
    ... rather whenever this formula returns a negative value it should display ... This spreadsheet is a dynamically linked to an online data source ... the formula value to automatically update itself as the cell values ... "Don Guillett" wrote: ...
    (microsoft.public.excel.misc)