In your 'practical advice', you forgot to ensure that the cell is NOT formatted as text. Because if the cell is formatted as text (C1:C34), then editing the cell by F2 & Enter isn't practical at all. Practical advice would be to highlight the cells C1:C34, ensure formatted as general (or if preferred, as number). Type a 0 into an empty cell. Copy that cell, then select your range C1:C34, Paste Special --> select Add and OK out. -- ** John C ** "Satti Charvak" wrote: > I'll give a practical advise (One of those clerical problems) > > go to cell C1 > > hit "F2" key and then followed by "Enter" Key > > cell c1 is converted to number. > > > the selection will go to cell c2 > > Do the above activity 33 more time and you are done > -- > Kind Regards, > Satti Charvak > Only an Excel Enthusiast > Noida, India > > > "Ron Rosenfeld" wrote: > > > On Sat, 8 Nov 2008 05:54:01 -0800, LionR <LionR@discussions.microsoft.com> > > wrote: > > > > >I set up a formula adding a set of numbers in a column, e.g.=sum(c1:c34). > > >The formula is correct but I got a zero as an answer. I set up the same > > >formula in another column and it gives me the correct answer, e.g. $2,500. I > > >tried copying this formula to the first one on the same row. And it returns > > >$2,500. > > > > > >What is going on? > > > > Possibly your "numbers" in c1:c34 are text. > > > > What do you get if, in some cell, you type: =istext(c1) > > > > How are the data entered in column C? > > --ron > >

0 |

11/10/2008 4:29:01 PM

I said type a 0 in an empty cell, as is a double check that they aren't adding hidden characters that may be a random blank cell they copy. -- ** John C ** "Peo Sjoblom" wrote: > No need to type 0 into the cell, copy an empty cell is enough > > -- > > > Regards, > > > Peo Sjoblom > > "John C" <johnc@stateofdenial> wrote in message > news:291DD943-2CBF-487C-8502-1E7E054CC734@microsoft.com... > > In your 'practical advice', you forgot to ensure that the cell is NOT > > formatted as text. Because if the cell is formatted as text (C1:C34), then > > editing the cell by F2 & Enter isn't practical at all. > > Practical advice would be to highlight the cells C1:C34, ensure formatted > > as > > general (or if preferred, as number). Type a 0 into an empty cell. Copy > > that > > cell, then select your range C1:C34, Paste Special --> select Add and OK > > out. > > -- > > ** John C ** > > > > "Satti Charvak" wrote: > > > >> I'll give a practical advise (One of those clerical problems) > >> > >> go to cell C1 > >> > >> hit "F2" key and then followed by "Enter" Key > >> > >> cell c1 is converted to number. > >> > >> > >> the selection will go to cell c2 > >> > >> Do the above activity 33 more time and you are done > >> -- > >> Kind Regards, > >> Satti Charvak > >> Only an Excel Enthusiast > >> Noida, India > >> > >> > >> "Ron Rosenfeld" wrote: > >> > >> > On Sat, 8 Nov 2008 05:54:01 -0800, LionR > >> > <LionR@discussions.microsoft.com> > >> > wrote: > >> > > >> > >I set up a formula adding a set of numbers in a column, > >> > >e.g.=sum(c1:c34). > >> > >The formula is correct but I got a zero as an answer. I set up the > >> > >same > >> > >formula in another column and it gives me the correct answer, e.g. > >> > >$2,500. I > >> > >tried copying this formula to the first one on the same row. And it > >> > >returns > >> > >$2,500. > >> > > > >> > >What is going on? > >> > > >> > Possibly your "numbers" in c1:c34 are text. > >> > > >> > What do you get if, in some cell, you type: =istext(c1) > >> > > >> > How are the data entered in column C? > >> > --ron > >> > > > >

0 |

11/10/2008 5:53:02 PM

Type ="" into a cell, then, copy that cell, and paste special with your range, doesn't work. -- ** John C ** "Peo Sjoblom" wrote: > Well if you are unsure if the cell contains hidden characters then you > should be unsure that the cell is formatted as text as well so the zero > wouldn't help much in that case. The fastest way otherwise would be to make > sure the numbers seen as text are formatted as general or numbers then do > data>text to columns and click finish > > -- > > > Regards, > > > Peo Sjoblom > > "John C" <johnc@stateofdenial> wrote in message > news:7FB56EF8-FBBE-4974-A955-5C3493B9EE23@microsoft.com... > >I said type a 0 in an empty cell, as is a double check that they aren't > > adding hidden characters that may be a random blank cell they copy. > > -- > > ** John C ** > > > > > > "Peo Sjoblom" wrote: > > > >> No need to type 0 into the cell, copy an empty cell is enough > >> > >> -- > >> > >> > >> Regards, > >> > >> > >> Peo Sjoblom > >> > >> "John C" <johnc@stateofdenial> wrote in message > >> news:291DD943-2CBF-487C-8502-1E7E054CC734@microsoft.com... > >> > In your 'practical advice', you forgot to ensure that the cell is NOT > >> > formatted as text. Because if the cell is formatted as text (C1:C34), > >> > then > >> > editing the cell by F2 & Enter isn't practical at all. > >> > Practical advice would be to highlight the cells C1:C34, ensure > >> > formatted > >> > as > >> > general (or if preferred, as number). Type a 0 into an empty cell. Copy > >> > that > >> > cell, then select your range C1:C34, Paste Special --> select Add and > >> > OK > >> > out. > >> > -- > >> > ** John C ** > >> > > >> > "Satti Charvak" wrote: > >> > > >> >> I'll give a practical advise (One of those clerical problems) > >> >> > >> >> go to cell C1 > >> >> > >> >> hit "F2" key and then followed by "Enter" Key > >> >> > >> >> cell c1 is converted to number. > >> >> > >> >> > >> >> the selection will go to cell c2 > >> >> > >> >> Do the above activity 33 more time and you are done > >> >> -- > >> >> Kind Regards, > >> >> Satti Charvak > >> >> Only an Excel Enthusiast > >> >> Noida, India > >> >> > >> >> > >> >> "Ron Rosenfeld" wrote: > >> >> > >> >> > On Sat, 8 Nov 2008 05:54:01 -0800, LionR > >> >> > <LionR@discussions.microsoft.com> > >> >> > wrote: > >> >> > > >> >> > >I set up a formula adding a set of numbers in a column, > >> >> > >e.g.=sum(c1:c34). > >> >> > >The formula is correct but I got a zero as an answer. I set up the > >> >> > >same > >> >> > >formula in another column and it gives me the correct answer, e.g. > >> >> > >$2,500. I > >> >> > >tried copying this formula to the first one on the same row. And > >> >> > >it > >> >> > >returns > >> >> > >$2,500. > >> >> > > > >> >> > >What is going on? > >> >> > > >> >> > Possibly your "numbers" in c1:c34 are text. > >> >> > > >> >> > What do you get if, in some cell, you type: =istext(c1) > >> >> > > >> >> > How are the data entered in column C? > >> >> > --ron > >> >> > > >> > >> > >> > > >

0 |

11/10/2008 6:43:01 PM

And all new users know the difference between empty cell and a cell that looks empty. Yep, you bet. -- ** John C ** "Peo Sjoblom" wrote: > But then it is not empty, I said empty cells, cells with formulas are not > empty > > -- > > > Regards, > > > Peo Sjoblom > > "John C" <johnc@stateofdenial> wrote in message > news:1564B700-3AF6-4E57-AD39-7B99F7AD3662@microsoft.com... > > Type ="" into a cell, then, copy that cell, and paste special with your > > range, doesn't work. > > -- > > ** John C ** > > > > "Peo Sjoblom" wrote: > > > >> Well if you are unsure if the cell contains hidden characters then you > >> should be unsure that the cell is formatted as text as well so the zero > >> wouldn't help much in that case. The fastest way otherwise would be to > >> make > >> sure the numbers seen as text are formatted as general or numbers then do > >> data>text to columns and click finish > >> > >> -- > >> > >> > >> Regards, > >> > >> > >> Peo Sjoblom > >> > >> "John C" <johnc@stateofdenial> wrote in message > >> news:7FB56EF8-FBBE-4974-A955-5C3493B9EE23@microsoft.com... > >> >I said type a 0 in an empty cell, as is a double check that they aren't > >> > adding hidden characters that may be a random blank cell they copy. > >> > -- > >> > ** John C ** > >> > > >> > > >> > "Peo Sjoblom" wrote: > >> > > >> >> No need to type 0 into the cell, copy an empty cell is enough > >> >> > >> >> -- > >> >> > >> >> > >> >> Regards, > >> >> > >> >> > >> >> Peo Sjoblom > >> >> > >> >> "John C" <johnc@stateofdenial> wrote in message > >> >> news:291DD943-2CBF-487C-8502-1E7E054CC734@microsoft.com... > >> >> > In your 'practical advice', you forgot to ensure that the cell is > >> >> > NOT > >> >> > formatted as text. Because if the cell is formatted as text > >> >> > (C1:C34), > >> >> > then > >> >> > editing the cell by F2 & Enter isn't practical at all. > >> >> > Practical advice would be to highlight the cells C1:C34, ensure > >> >> > formatted > >> >> > as > >> >> > general (or if preferred, as number). Type a 0 into an empty cell. > >> >> > Copy > >> >> > that > >> >> > cell, then select your range C1:C34, Paste Special --> select Add > >> >> > and > >> >> > OK > >> >> > out. > >> >> > -- > >> >> > ** John C ** > >> >> > > >> >> > "Satti Charvak" wrote: > >> >> > > >> >> >> I'll give a practical advise (One of those clerical problems) > >> >> >> > >> >> >> go to cell C1 > >> >> >> > >> >> >> hit "F2" key and then followed by "Enter" Key > >> >> >> > >> >> >> cell c1 is converted to number. > >> >> >> > >> >> >> > >> >> >> the selection will go to cell c2 > >> >> >> > >> >> >> Do the above activity 33 more time and you are done > >> >> >> -- > >> >> >> Kind Regards, > >> >> >> Satti Charvak > >> >> >> Only an Excel Enthusiast > >> >> >> Noida, India > >> >> >> > >> >> >> > >> >> >> "Ron Rosenfeld" wrote: > >> >> >> > >> >> >> > On Sat, 8 Nov 2008 05:54:01 -0800, LionR > >> >> >> > <LionR@discussions.microsoft.com> > >> >> >> > wrote: > >> >> >> > > >> >> >> > >I set up a formula adding a set of numbers in a column, > >> >> >> > >e.g.=sum(c1:c34). > >> >> >> > >The formula is correct but I got a zero as an answer. I set up > >> >> >> > >the > >> >> >> > >same > >> >> >> > >formula in another column and it gives me the correct answer, > >> >> >> > >e.g. > >> >> >> > >$2,500. I > >> >> >> > >tried copying this formula to the first one on the same row. > >> >> >> > >And > >> >> >> > >it > >> >> >> > >returns > >> >> >> > >$2,500. > >> >> >> > > > >> >> >> > >What is going on? > >> >> >> > > >> >> >> > Possibly your "numbers" in c1:c34 are text. > >> >> >> > > >> >> >> > What do you get if, in some cell, you type: =istext(c1) > >> >> >> > > >> >> >> > How are the data entered in column C? > >> >> >> > --ron > >> >> >> > > >> >> > >> >> > >> >> > >> > >> > >> > > >

0 |

11/10/2008 8:27:01 PM