Excel - Invisible Text designation in cell?

[mshanaha]

Using paste special of a formula (values) and replace all, spreadsheet
developed annoying habit of only working in the first cell of range and
remainder seem to be text only fields even though there was no format for
text on the cell.

Deleting cells and repasting did not help.

Pasting elsewhere did not help.

Workaround was redeveloping underlying formula for pasting which is
extremely time consuming. Have never seen this before.

Any suggestions ????

 

[Carey Frisch [MVP]]

Please visit the experts in the Excel newsgroup:
news://msnews.microsoft.com/microsoft.public.excel

--
Carey Frisch
Microsoft MVP
Windows XP - Shell/User
Microsoft Newsgroups

-------------------------------------------------------------------------------------------

:

| Using paste special of a formula (values) and replace all, spreadsheet
| developed annoying habit of only working in the first cell of range and
| remainder seem to be text only fields even though there was no format for
| text on the cell.
|
| Deleting cells and repasting did not help.
|
| Pasting elsewhere did not help.
|
| Workaround was redeveloping underlying formula for pasting which is
| extremely time consuming. Have never seen this before.
|
| Any suggestions ????

 

[mshanaha]

I was advised to post in the managed newsgroups. Is the newsgroup you
recommend a managed newsgroup?