Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Why does "=SUM(E4,E8,E11,E14,E17)" display as text?

I have entered this formula in a spreadsheet and wonder why it displays the
formula "=SUM(E4,E8,E11,E14,E17)" as text?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,836
Default Why does "=SUM(E4,E8,E11,E14,E17)" display as text?

Right-click the cells you are referencing, and the cell you are doing your
calculation in. Select Format Cells. are any of those cells formatted as
Text? Format as General and try again.

HTH,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"blessed grandma" wrote:

I have entered this formula in a spreadsheet and wonder why it displays the
formula "=SUM(E4,E8,E11,E14,E17)" as text?

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 698
Default Why does "=SUM(E4,E8,E11,E14,E17)" display as text?

You show the example in quotes...

If using quotes in the sheet, then remove them, although I suspect you are
just using quotes in your post and not in the worksheet.

HTH
Regards,
Howard

"ryguy7272" wrote in message
...
Right-click the cells you are referencing, and the cell you are doing your
calculation in. Select Format Cells. are any of those cells formatted as
Text? Format as General and try again.

HTH,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"blessed grandma" wrote:

I have entered this formula in a spreadsheet and wonder why it displays
the
formula "=SUM(E4,E8,E11,E14,E17)" as text?



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Why does "=SUM(E4,E8,E11,E14,E17)" display as text?

Most likely is that your formula cell was earlier (unknown to you of course)
pre-formatted as TEXT. Reformat the cell to either general or number (via
clicking FormatCells ..), and then reconfirm the formula, ie: click inside
the formula bar, press ENTER, and all would be well.

Another possibility, albeit remote, is that you are in formula view. Press
CTRL+` to toggle it back to normal. The ` key is the one just to the left of
the "1" on your keyboard.

Success? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"blessed grandma" wrote:
I have entered this formula in a spreadsheet and wonder why it displays the
formula "=SUM(E4,E8,E11,E14,E17)" as text?

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Why does "=SUM(E4,E8,E11,E14,E17)" display as text?

Yes, the quotes were only in the post. The first response helped - apparently
somewhere in the field of cells there was a cell formatted as text instead of
numeric even though I thought I had the whole thing formatted as numbers.

"L. Howard Kittle" wrote:

You show the example in quotes...

If using quotes in the sheet, then remove them, although I suspect you are
just using quotes in your post and not in the worksheet.

HTH
Regards,
Howard

"ryguy7272" wrote in message
...
Right-click the cells you are referencing, and the cell you are doing your
calculation in. Select Format Cells. are any of those cells formatted as
Text? Format as General and try again.

HTH,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"blessed grandma" wrote:

I have entered this formula in a spreadsheet and wonder why it displays
the
formula "=SUM(E4,E8,E11,E14,E17)" as text?



.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
How do I change the column heading in Excel to display "A" "B" "C Thai New Users to Excel 1 November 30th 07 08:06 PM
How to display numbers as text? Ex: 203 = "two hundred, three" Dann the Mann Excel Worksheet Functions 1 June 8th 07 03:47 PM
How do I display the "ampersand" in the header as text Mark10101010 Setting up and Configuration of Excel 1 May 15th 06 04:01 PM
Insert "-" in text "1234567890" to have a output like this"123-456-7890" Alwyn Excel Discussion (Misc queries) 3 October 25th 05 11:36 PM


All times are GMT +1. The time now is 12:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"