Never saw this before - What is it?

[Dennisr53]

Hi Everyone,

I recently downloaded some data from Medi Tech and received the following date information. I have never seen the icon in front of the date. What is it? I cannot click on it or drill down into the date but it does not allow me to use the date as a date.

it appears to be a text box with a ? in it but, it will not copy it. When I copy the cell it only gives me the date.

Sorry I cannot show it to you but I can't seem to snag it.

Thanks,
Dennis

 

[Weazel]

sounds like it might be a web object....try hitting F5....click special....tick Objects....click ok then hit delete

 

[Dennisr53]

sounds like it might be a web object....try hitting F5....click special....tick Objects....click ok then hit delete

Thanks for the quick response Weazel but, when I try it I get "No objects found"

 

[MARK858]

Try using find/replace. Select your data then...

In the find box hold ALT and type on the numeric pad 0010, leave the replace box blank and click OK, if this doesn't work try the same with 0013.
Finally try the same with 0127

 

[Dennisr53]

Hi Mark858,

I tried what you said but the Find/replace does not have a "ok" to click and when I hold down the ALT key and type on the numeric pad nothing is displayed as though I am not typing anything. Tried all three of your numbers and only get Microsoft cannot find the data you are looking for.

Thanks for trying though,
Dennis

PS. Do not know if it helps but, I am using Excel 2010 on windows 7

 

[MARK858]

Sorry was on my phone and so couldn't check but it should have been replace all not OK and also you need to go into options and make sure that "match entire cell contents" isn't checked (if it was uncheck it and try the procedure again)

If it wasn't checked what does

=CODE(A1)

where A1 is the cell with the offending icon give you?

 

[Dennisr53]

Sorry was on my phone and so couldn't check but it should have been replace all not OK and also you need to go into options and make sure that "match entire cell contents" isn't checked (if it was uncheck it and try the procedure again)

If it wasn't checked what does where A1 is the cell with the offending icon give you?

Sorry Mark858 but, still get nothing (same response).

I do not see any way to attach/insert a file here to show you, so here is my direct email E-Mail Address Removed - Moderator if you send me an email I will reply and attach a file that shows the issue( it is only 10KB)

Thanks for trying,
Dennis

 

[MARK858]

If it wasn't checked what does

 =CODE(A1)

where A1 is the cell with the offending icon give you?

You didn't answer what the formula above gave you...


I don't give out my email address. If you want us to see your workbook go to www.box.com upload your workbook to there, click share and copy the link it gives you in the thread.
Answer the question above first though.

 

[Dennisr53]

Microsoft sates "Microsoft Excel cannot find any data to replace. Check if your search formatting and criteria are defined correctly. If you are sure that matching data exists in this workbook, it may be on a protected sheet. Excel cannot replace data on a protected worksheet."

 

[MARK858]

A) turn off your sheet protection if you have it on

B) for the last time answer the question below

If it wasn't checked what does

=CODE(A1)

where A1 is the cell with the offending icon give you?

in case it isn't clear put the formula in an empty cell and change A1 to whatever cell reference holds the question mark.