+ Reply to Thread
Results 1 to 2 of 2

All text cells converted to #VALUE

  1. #1
    Registered User
    Join Date
    08-31-2010
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    1

    All text cells converted to #VALUE

    Hi,

    My mother (of all people) is managing a 2000+ row xls for her real estate business. It has column headers for ID, Description, Price, No of bedrooms etc and is a simple data entry tool with no formulas. Recently she has sent it to me with an issue. All of the cells containing text (inc column headers) are now showing #VALUE!. All of the cells containing numbers have no issues and the numbers are showing correctly. I quizzed her and she doesnt recall doing anything specific that would have done this. I have google searched to no avail - any help from you wise people would be sincerely appreciated!

    A very bemused,

    Gareth

  2. #2
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile Re: All text cells converted to #VALUE

    Good afternoon garjones

    ...and welcome to the forum!!

    You might be better off attaching the workbook.

    You can probably delete most of the 2000+ rows, and just leave a little data there so we can see exactly what you mean.
    Feel free to change any details in the workbook that might identify individuals / locations, as long as the basic problem remains.

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1