Can you exceed 15 number characters in an excel cell?

  • Thread starter Thread starter Bailey
  • Start date Start date
B

Bailey

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.
 
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.
Click to expand...

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


--ron
 
Back
Top