| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't see cell information in excel but it is in the formula bar
I can't see cell information in excel but it is in the formula bar, can you
tell me what happened? How to fix it? Any help would be much appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can't see cell information in excel but it is in the formula bar
Make sure your font colour is set to black
-- Hth Kassie Kasselman "MPTL06" wrote: I can't see cell information in excel but it is in the formula bar, can you tell me what happened? How to fix it? Any help would be much appreciated. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can't see cell information in excel but it is in the formula bar
Make sure that the color of the font is not the same as the background color.
-- Gary's Student gsnu200701 "MPTL06" wrote: I can't see cell information in excel but it is in the formula bar, can you tell me what happened? How to fix it? Any help would be much appreciated. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can't see cell information in excel but it is in the formula bar
One other option....
If the cell has a custom number format of ;;; you'd have the same symtoms. If that's the case, just change the number format to whatever is reasonable. <format<cells<number tab select a format Does that help? *********** Regards, Ron XL2002, WinXP "MPTL06" wrote: I can't see cell information in excel but it is in the formula bar, can you tell me what happened? How to fix it? Any help would be much appreciated. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can't see cell information in excel but it is in the formula b
"symtoms" should be "symptoms"!
*********** Regards, Ron XL2002, WinXP "Ron Coderre" wrote: One other option.... If the cell has a custom number format of ;;; you'd have the same symtoms. If that's the case, just change the number format to whatever is reasonable. <format<cells<number tab select a format Does that help? *********** Regards, Ron XL2002, WinXP "MPTL06" wrote: I can't see cell information in excel but it is in the formula bar, can you tell me what happened? How to fix it? Any help would be much appreciated. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can't see cell information in excel but it is in the formula b
Ron Coderre,
Thank you for the reply. I had already checked the font color of text and the cell color, they were fine. I tried to unwrap the text and it showed up, but I had to resave and it still was acting up, then I figured out it was my dual monitor settings. It now works! I am not sure why it did that or how the dual monitor affected it. Thanks again, MPTL06 "Ron Coderre" wrote: One other option.... If the cell has a custom number format of ;;; you'd have the same symtoms. If that's the case, just change the number format to whatever is reasonable. <format<cells<number tab select a format Does that help? *********** Regards, Ron XL2002, WinXP "MPTL06" wrote: I can't see cell information in excel but it is in the formula bar, can you tell me what happened? How to fix it? Any help would be much appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| need Excel cell to show value, not formula | Excel Worksheet Functions | |||
| Excel Formula using relative position of cells in two different worksheets | Excel Worksheet Functions | |||
| On excel, my formula will not calculate and add info into cell | Excel Worksheet Functions | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Linear Mode
