MS Excel - The word 'value' appearing in cells
Thread poster: Sarah Port

Sarah Port  Identity Verified
Local time: 19:48
German to English
+ ...
Dec 13, 2007

I have a problem with the cell format in Microsoft Excel for Windows XP.

The word 'value' now appears in certain cells on my spreadsheet instead of numerals although numerals have already been inputted.

How do I restore the actual numerals?

Many thanks in advance,

Sarah


Direct link Reply with quote
 

Renée van Bijsterveld  Identity Verified
Netherlands
Local time: 20:48
Member (2007)
English to Dutch
+ ...
change cell formatting Dec 13, 2007

You could try to change the cell formatting to numbers: select the cell, choose Formatting > Cell properties (I hope these are the options, I use the dutch version). You may need to re-enter your numerals after changing the formatting.
Good luck,
Renée


Direct link Reply with quote
 

Giles Watson  Identity Verified
Italy
Local time: 20:48
Italian to English
Check the Help file Dec 13, 2007

Hi Sarah,

If you search for VALUE in the Excel Help file, you'll find a number of possible reasons for this.

When it happens to me, it usually means that I've copied a cell containing a formula that is not valid in the new position or I'm trying to input text into a cell where there should be a number.

HTH

Giles


Direct link Reply with quote
 

Parrot  Identity Verified
Spain
Local time: 20:48
Member (2002)
Spanish to English
+ ...
You've changed a cell containing an equation Dec 13, 2007

In cells containing equations, you don't need to input numerals. The equation solves these by getting input from other cells (the equation would refer to other columns).

IF: the problem occurs in the cell where the word VALUE appears, select that block with the mouse starting from the line above the word VALUE. Go to EDIT, choose FILL and click on DOWNWARD. That restores the equation.

IF: the problem does not occur in the VALUE cell, check the decimal points/commas in the cells where you placed your input (i.e., the cells mentioned in the equation). Use the original language format. It will be up to your client to change the language of the entire file (you can't just interchange separators and decimal points - they don't "translate". The entire file system has to change language).

Hope it helps!


Direct link Reply with quote
 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

MS Excel - The word 'value' appearing in cells

Advanced search






WordFinder
The words you want Anywhere, Anytime

WordFinder is the market's fastest and easiest way of finding the right word, term, translation or synonym in one or more dictionaries. In our assortment you can choose among more than 120 dictionaries in 15 languages from leading publishers.

More info »
LSP.expert
You’re a freelance translator? LSP.expert helps you manage your daily translation jobs. It’s easy, fast and secure.

How about you start tracking translation jobs and sending invoices in minutes? You can also manage your clients and generate reports about your business activities. So you always keep a clear view on your planning, AND you get a free 30 day trial period!

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums