Thread: Find and Replace causing a "Text" cell to become a custom date--wh
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Benjamino5 Benjamino5 is offline
external usenet poster
  
Posts: 3
Default Find and Replace causing a "Text" cell to become a custom date
Just found an interesting link related to this:
http://www.bluemoosetech.com/article.php?jid=6

"Benjamino5" wrote:

Niek,

That worked--thanks! Do you have any links to more information about this?
I'm not sure why your trick worked, and I'd like to learn Excel.

Ben

"Niek Otten" wrote:

<Why is this happening?
Sometimes Excel is just too "helpful"

<How can I stop it?
Replace "Page: " with a single quote. It will not show in the cell but will cause the result to be treated as text

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

Reply With QuoteReply With Quote