Problem with returning value in Excel formula

Hi,

I have two sheets where the values ​​are entered in column A of sheet 1 will be copied to column A in sheet 2.

It works in most cells. However, there are some cells in sheet 2 that instead return ####.

for example:

In sheet 1, column A, row 32, I have 555 of valuation input and sheet 2, column A, line 32 formula:

= IF ('Sheet1'! A32 = 0, "", 'Sheet1'! A32), which returns the value 555

On row 33, I have the same combination but here it becomes #### in sheet 2.


I know it's not about the cell is too small, the input value which can cause error #####


Someone who understands what's wrong?


Grateful for help

Regards

Fredrik

= IF('Sheet1'!A33=0,"",'Sheet1'!A33)

Sorry if I was a bit fuzzy, but this is an excerpt from my file that represents row 50-54 in sheets 1-2, column A-B.

Skärmavbild 2014-05-07 kl. 22.12.10.jpg

If I delete the numbers that do not work and enter them again, it seems work out better. So it goes of course to solve. However, interesting to know why there are errors in some cells in the first place.

Most of all, I would like to add a macro that handles this, but unfortunately not the knowledge in VBA.

Thanks för the help!


Regard

Fredrik

Format cell as text

Ha, that simple!

Thanks!

It worked out fine when I formated the column as text.