Cell entries display problem.

[Kim-Anh Tran]

A10 is Sum(A1:A9). When I enter values in these cells, cells A1, A2, A3,
and A4 do not display values,however, the values is there!A10 shows
correct sum and the values appears on the print screen. How have no
idea how this happens. Please help!
Thanks in advance!

 

[Gord Dibben]

Kim

Couple of suggestions.

1. The Font is formatted to White(no color is default)

2. You have Custom Format of ;;; for those cells.

Gord Dibben Excel MVP

 

[A.W.J. Ales]

Or (what iI had myself recently as a "problem") you have a conditional
format on those cell ( white font on white background) and the condition is
met.

(More or less the same as Gord's first suggestion, but harder to find. I
myself had this situation by copying a cell without realising that the cell
had a conditional format).

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

 

[Kim-Anh Tran]

It's was white color for "font"! I am glad it's easy to fix.
I am sorry that I don't know how to reply or post to Newsgroup. I clic
on the icon "Post reply" or new Post. Your instructio is wel
appreciated!
Thanks again for your help

 

[Lady Layla]

Click reply group
: It's was white color for "font"! I am glad it's easy to fix.
: I am sorry that I don't know how to reply or post to Newsgroup. I click
: on the icon "Post reply" or new Post. Your instructio is well
: appreciated!
: Thanks again for your help!
:
:
: ---
:
:

 

[Kim-Anh Tran]

I can't find the Reply group button or link any where. I only see Ne
Threat and Reply Post Icon! Where is reply group located?
Thanks,
Kim-An

 

[Lady Layla]

Sorry just realized you are using web site -- all previous instructions were
for those using OE to read the newsgroup


You are replying in the group == reply post is what you want


: I can't find the Reply group button or link any where. I only see New
: Threat and Reply Post Icon! Where is reply group located?
: Thanks,
: Kim-Anh
:
:
: ---
:
: