IN MS-EXCEL 2003 HOW LONG A FORMULA CAN BE IN AND HOW MANY CHARACTERS CAN BE ENTERED IN A CELL ?

Question and answer

Question

Asked 10/25/2011 4:53:37 AM

0 Answers/Comments

This answer has been confirmed as correct and helpful.

Get an answer

Search for an answer or ask Weegy.

Original conversation

User: IN MS-EXCEL 2003 HOW LONG A FORMULA CAN BE IN AND HOW MANY CHARACTERS CAN BE ENTERED IN A CELL ?

Weegy: In Excel 2003 and above, you can have up to 32K characters in a worksheet cell, but only the first 1000 or so are displayed (the exact number depends on your font and display characteristics). [ [ However, you can increase the number of characters displayed if you add line breaks in the cell (press Alt+Enter). ]
Expert answered|rhyann24|Points 2255|

User: AND WHAT ABOUT FORMULA ?

Weegy: One cell in Excel can hold 32,767 characters. [ The maximum you can see in a cell on the worksheet is 1,024, but all 32,767 are shown in the formula bar. Read more: ]
Expert answered|jher000|Points 6039|

Question

Asked 10/25/2011 4:53:37 AM

0 Answers/Comments

This answer has been confirmed as correct and helpful.

New answers

Rating

There are no new answers.

Comments

There are no comments.

Add an answer or comment

Questions asked by the same visitor

IN MS-EXCEL 2003,how many characters can be entered in a cell ?

Weegy: In Excel 2003 and above, you can have up to 32K characters in a worksheet cell, but only the first 1000 or so are displayed (the exact number depends on your font and display characteristics). [ However, you can increase the number of characters displayed if you add line breaks in the cell (press Alt+Enter). ] (More)

Question

Expert Answered

Asked 10/25/2011 4:31:54 AM

0 Answers/Comments