How not to show black mark in upper left corner on cells, data entered by formula

[Launchnet]

I have 2 columns. Column BC has date i.e. 12-6-1974 (Birthdate). This is OK. This columns data is manually entered.

Column BD has a formula that extracts out the name of the month and displays it in column BD. Formula is: =IF(BC12="","",TEXT(BC12,"mmmm")) This also works properly.

The only problem is that in the upper left corner of all cells in column BD, there is a black mark. I do not want this to show.

Any suggestions

[bebo021999]

I tried but no "black mark" anyway.

Try to click into "black mark" and what it tells you?

Could you pls take PrtSc (Print screen) and post a picture up?

[Launchnet]

Haven't used the print screen in so many years, I forget how to use it. Please update me.
Thanks

[bebo021999]

Press PrtScr button on your keyboard, open "Paint" program and paste (Ctrl-V), save as JPEG format.
In forum screen, press Insert Image button to attach the image file.

[Launchnet]

Here it is. Look at the picture column Men's Birth Date and column Month

Month column has the black marks and so does Combined 1st & Last Name column.

I have thought about this for a long time and I guess that something is set for the entire workbook to show where there are formulas. I think that is the only time it appears.

ScreenPrint.jpg

I just checked another tab and it doesn't happen on that worksheet. So, it must be something turned on on this sheet.

Good Luck . . . as I can't find it.

[bebo021999]

Normally these are notices from excel about invalid data format
So try to click to the mark and tell what excel says? just follow excel's guildance

[royUK]

They look like the green triangles that indicate various possible errors, in this case I would think they are telling you that the cells contain formulas but are not protected. Hover the cursor over one of the cells to see the error message

[Launchnet]

Thanks you guys . Thats what it was. Now I know how to handle.

Thanks