Can you exceed 15 number characters in an excel cell?
 

I am trying to concatenate two cells which between them contain 16 numbers.
However in the concat, the last number is being replaced with 0. I have found
that a cell can only contain 15 number characters, is it possible to exceed
this to 16 characters and if so, how? Thanks.

Can you exceed 15 number characters in an excel cell?
 

On Mon, 28 Jan 2008 04:02:00 -0800, Bailey
wrote:

I am trying to concatenate two cells which between them contain 16 numbers.
However in the concat, the last number is being replaced with 0. I have found
that a cell can only contain 15 number characters, is it possible to exceed
this to 16 characters and if so, how? Thanks.

Format the cell as TEXT, or precede your entry with a single quote (')


--ron