I am trying to put long numbers in crosstab cells (my end goal is to transform the numbers to little balls for display purpose using a special font). It seems to work fine with number that are up to 10 positions..
So 1111111111 works fine
But 1111111111111111111 returns a weird result.. it will display 307163591
I tried formatting the cells but that didn't help. Is there a maximum on the length a number can have in a crosstab?
I'm not sure about the length limit, but instead of using font to display images, you might find working with conditionally displayed images a lot more flexible.
Quote from: icepick on 16 Aug 2012 04:10:45 AM
I am trying to put long numbers in crosstab cells (my end goal is to transform the numbers to little balls for display purpose using a special font). It seems to work fine with number that are up to 10 positions..
So 1111111111 works fine
But 1111111111111111111 returns a weird result.. it will display 307163591
I tried formatting the cells but that didn't help. Is there a maximum on the length a number can have in a crosstab?
Yes, there is a limit, but it should be higher than 10 positions. We recently ran into problems with very small values that caused arethmetic overflow. There is an KB article describing this in detail. It has to do with what can be represented within a crosstab . Strange that you do not get an overflow error..