|
| Number as text |
 |
Tue, 15 Jan 2008 10:31:31 -080 |
I need to enter a number (2007) in a cell but don't want it to be included
in a sum of cells that include that cell.
I tried changing to "text" but it still gets added to the totaling
cell. Is
there a command that will make that cell not look like a number?
Thanks
|
| Post Reply
|
| Re: Number as text |
 |
Tue, 15 Jan 2008 10:46:38 -080 |
Tried that. Doesn't work. It does take it out of the sum but prints as
2007".
Try it.
Any better solution?
"David Reese" <reeseco@neo.rr.com> wrote in message
news:478cfde1$1_2@cnews...
>
> Try putting quotes around it.
>
> Scott W wrote:
>> I need to enter a number (2007) in a cell but don't want it to be
>> included in a sum of cells that include that cell.
>> I tried changing to "text" but it still gets added to the
totaling cell.
>> Is there a command that will make that cell not look like a number?
>> Thanks
>
|
| Post Reply
|
| Re: Number as text |
 |
Tue, 15 Jan 2008 10:56:20 -080 |
Single quote in front works!
I was putting one in front & end.
Thank you for your helpful reply
Scott
"Tim" <no.spam@hotmail.com> wrote in message
news:478cff5d$1_3@cnews...
>
> David Reese wrote:
>>
>> Try putting quotes around it.
>
> or a single quote in front of it
>>
>> Scott W wrote:
>>> I need to enter a number (2007) in a cell but don't want it to be
>>> included in a sum of cells that include that cell.
>>> I tried changing to "text" but it still gets added to the
totaling cell.
>>> Is there a command that will make that cell not look like a
number?
>>> Thanks
>>>
>>>
>>
>
|
| Post Reply
|
| Re: Number as text |
 |
Tue, 15 Jan 2008 12:46:38 -060 |
David Reese wrote:
>
> Try putting quotes around it.
or a single quote in front of it
>
> Scott W wrote:
>> I need to enter a number (2007) in a cell but don't want it to be
>> included in a sum of cells that include that cell.
>> I tried changing to "text" but it still gets added to the
totaling
>> cell. Is there a command that will make that cell not look like a
number?
>> Thanks
>>
>>
>
|
| Post Reply
|
| Re: Number as text |
 |
Tue, 15 Jan 2008 13:39:51 -050 |
Try putting quotes around it.
Scott W wrote:
> I need to enter a number (2007) in a cell but don't want it to be included
> in a sum of cells that include that cell.
> I tried changing to "text" but it still gets added to the
totaling cell. Is
> there a command that will make that cell not look like a number?
> Thanks
>
>
>
|
| Post Reply
|
|
|
|
|
|
|
|
|
|