Can you exceed 15 number characters in an excel cell?

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.
 
R

Ron Rosenfeld

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Urgent help needed? How do I limit the number of characters in a 5
Date/ Time Formula in Excel 2
Copying concatenate not returning correct cell information 6
15 digets 4
COUNT function - # of occurences a number appears in all cells 26
Can I auto count the # of characters in an excel cell? 10
rounding problem need accuracy when using V Lookup 2
limit number of characters in cell 4

Top