Help in copying formula

please help when i copied the formula #value! came out  but when i checked the fomula its ok

it seemed that it didnt capture the numbers in the cell it is supposed to compute

 

pls see my attachment

thanks in advance

AttachmentSize
Book1.xls34.5 KB
Book1_june-14.xls33 KB
Nick's picture

not a number

hi Ron... your problem is that your numbers are not numbers Have a look on that line, and you will see this:

"      33,015.34 " (cell W8)

Excel understands it as a piece of text due to the extra space around the number.

Solution:

  1. Select cell W8
  2. Press F2
  3. Press HOME
  4. Press SHIFT, hold it down, and press the right arrow once
  5. Press CTRL + C
  6. Press Escape
  7. Press CTRL + H (to replace)
  8. Select the "Find What" field
  9. Press CTRL + V (to paste)
  10. Press ALT + A (to replace All)

I've attached a working file to ur post

Nick

Help in copying formula

and nick how could i learn this

which key to press and the step by step

solution to this kind of problem

thanks in advance

 

Nick's picture

Learn Excel

You'll find a lot of the answers here:

http://excelexperts.com/Teach-Yourself-Excel-Lesson-2-Course-Outline

Rgds

Nick