ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Cant type on line E31. (https://www.excelbanter.com/excel-worksheet-functions/255942-cant-type-line-e31.html)

tabatha anderson

Cant type on line E31.
 
I am trying to type on line E31, but it wont show the number on that line, it shows the number in the formula bar above.


Submitted via EggHeadCafe - Software Developer Portal of Choice
Generic Feed Parsers Redux
http://www.eggheadcafe.com/tutorials...sers-redu.aspx

JP[_4_]

Cant type on line E31.
 
Maybe the cell's font color is set to white?

--JP

On Feb 10, 11:48*am, tabatha anderson wrote:
I am trying to type on line E31, but it wont show the number on that line, it shows the number in the formula bar above.

Submitted via EggHeadCafe - Software Developer Portal of Choice
Generic Feed Parsers Reduxhttp://www.eggheadcafe.com/tutorials/aspnet/42a9b6e2-809e-4ca7-b3f6-a...



Teethless mama

Cant type on line E31.
 
Check to make sure it has black font on white background, if the cell has a
conditional formatting then clear the CF


"tabatha anderson" wrote:

I am trying to type on line E31, but it wont show the number on that line, it shows the number in the formula bar above.


Submitted via EggHeadCafe - Software Developer Portal of Choice
Generic Feed Parsers Redux
http://www.eggheadcafe.com/tutorials...sers-redu.aspx
.


Gord Dibben

Cant type on line E31.
 
E31 is a single cell, not a "line"

Does E31 have Conditional Formatting applied?

Is E31 custom formatted to ;;; (three semi-colons)?


Gord Dibben MS Excel MVP

On Wed, 10 Feb 2010 08:48:20 -0800, tabatha anderson wrote:

I am trying to type on line E31, but it wont show the number on that line, it shows the number in the formula bar above.


Submitted via EggHeadCafe - Software Developer Portal of Choice
Generic Feed Parsers Redux
http://www.eggheadcafe.com/tutorials...sers-redu.aspx



Bill Sharpe[_2_]

Cant type on line E31.
 
On 2/10/2010 8:48 AM, tabatha anderson wrote:
I am trying to type on line E31, but it wont show the number on that line, it shows the number in the formula bar above.


Submitted via EggHeadCafe - Software Developer Portal of Choice
Generic Feed Parsers Redux
http://www.eggheadcafe.com/tutorials...sers-redu.aspx


Push comes to shove, i.e. if all else fails, delete row 31, then insert
a new row. You'll, of course, have to type in all new info in that row.

Bill


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com