Excel 2007: All text cells converted to #VALUE

Microsoft Office excel 2007
May 29, 2012 at 08:17:17
Specs: Windows XP
I saw an old post for this issue (Excel: All text cells converted to #VALUE).
Has it been resolved?
I have seen the same problem in Excel 2007 and have been unable to determine why it happened.

See More: Excel 2007: All text cells converted to #VALUE

Report •

#1
June 4, 2012 at 07:29:07
Text cells cannot be used in expressions. Are you attempting to calculate something here?

Report •

#2
June 4, 2012 at 07:41:54
Thanks for your reply.
There are no calculations. The cells just have text in them. Even the column headers changed to "#VALUE".
The file has 3 sheets and the same thing happened on each sheet.

Report •

#3
June 4, 2012 at 11:46:54
Any rouge Macro's running?

Have you tried a Diagnostic?

Running Microsoft Office Diagnostics from within Excel/Word

Click the Microsoft Office button
Click on the Excel/Word Options button to bring up the Excel Options dialog box (at the bottom of window)
Click on the Resources button in the left hand pane
Click on the Diagnose button in the right hand pane
Click Continue
Click Run Diagnostics

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
June 5, 2012 at 09:45:29
Thanks Mike.

I ran the diagnostics. It had no effect on the file. Maybe it will prevent it from happening again. Who knows.
The more I look at it, the more I think this file is not recoverable. The actual text of all the text fields is now "#VALUE". The original text is no where to be found.

I'm just curious as to how it happened in the first place.


Report •

#5
June 5, 2012 at 11:44:02
In the Formula Bar, on the Ribbon, when you select a cell, does it also show #VALUE?

You could try the CELL() function, try:

=CELL("contents",A1) Displays the actual contents of the cell.
=CELL("type",A1) The type of entry in the cell. Showns b for blank, l for text, v for value.
and
=CELL("format",A1) If it has a number format, then this will show number format code for the cell.

They might give some clues.

MIKE

http://www.skeptic.com/


Report •

#6
June 6, 2012 at 07:58:56

Yes. The formula bar also displays "#VALUE".

I tried the CELL() functions you suggested.
"contents" displayed "#VALUE"
"type" displayed " v "
"format" displayed "G"

If you have anymore ideas about how this happened let me know. I think the file itself is toast.

Thanks,
Paul


Report •

#7
June 6, 2012 at 08:39:19
"type" displayed " v "

That's odd, should be an I for Text.

I think the file itself is toast.

I think your right.

MIKE

http://www.skeptic.com/


Report •

#8
June 26, 2012 at 08:54:28
Hi guys
I had the same - and more than once , no idea what causes it, in my case I can see the content in the cell in Excel but it won't show in Word merge fields. Funnily enough going in "format cell" menu the #### error is in the small preview window if the format is "general" or "text", while the right text is showed if the format is "number" or "date". Function Cell shows "v" in "type", "G" in "format" and the right text in "content" but test won't show up in merge fields , while it shows in vhookup but not in merge fields from vhookup. It's like Excel can't decide whether a cell is a text or a value. Weird .

Report •

Ask Question