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

 

[Smitty]

Dennis,

If you need to share your e-mail address with someone you can use the secure Private Message feature. Your personal information isn't safe from spammers, bots, etc. in this or any other public forum.

 

[Dennisr53]

sheet protection is not on.

I selected blank cell and put the code as shown above and referencing the questionable cell and I get 01/12/00 when the original date is 08/02/15

 

[MARK858]

format the cell with the formula as general not date. You should get a number

 

[Dennisr53]

Thanks Smitty,

I am a fairly new member. Can you tell me how to do that as I do not see that feature anywhere.

I see I am frustrating Mark858 unintentionally.

Thanks again,
Dennis

 

[Dennisr53]

number is 12

 

[MARK858]

I see I am frustrating Mark858 unintentionally.

Not now you aren't. see post #13

 

[MARK858]

number is 12

Do the same process as before but use ALT 0012.
If you can't get it to work we will do it with a macro....

 

[Dennisr53]

This time I get "Excel has completed its search and has made 66 replacements."

The only problem is nothing actually changed on the spreadsheet. And there are only 14 items on the spreadsheet.

 

[MARK858]

what is the =CODE() formula showing now for the cell?

The only problem is nothing actually changed on the spreadsheet. And there are only 14 items on the spreadsheet.

Character 12 is a non printing form feed and so you won't see any change because you can't see them.

 

[Dennisr53]

still 12