Number in cell does not display

User avatar
Sundog
5StarLounger
Posts: 704
Joined: 28 Jan 2010, 22:47
Location: Alien Country (Roswell NM)

Number in cell does not display

Post by Sundog »

Somehow I managed to insert a number into thousands of cells that used to be blank. This worksheet has other good data.

The number only displays in the top box adjacent to fx. I tried Replace All with the entire sheet selected; "We couldn't find anything to replace."

If I select a cell that appears blank, the number shows in the top box.

How do I get rid of that number but keep other good data?

I will try a snip:
Screenshot 2022-09-12 175016.png
You do not have the required permissions to view the files attached to this post.
Sundog

User avatar
Sundog
5StarLounger
Posts: 704
Joined: 28 Jan 2010, 22:47
Location: Alien Country (Roswell NM)

Re: Number in cell does not display

Post by Sundog »

Problem solved, by unknown forces. Excel crashed, rebooted, and when I displayed the file that had the error, it appears to disappeared. Gone into the ether?
Sundog

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Number in cell does not display

Post by HansV »

Probably temporary memory corruption, causing Excel to crash.
Best wishes,
Hans