| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Footer exceed max characters | Excel Worksheet Functions | |||
| How to set number of characters within a cell in Excel 2003? | Excel Worksheet Functions | |||
| Sum of previous offset number of cells not to exceed certain value | Excel Worksheet Functions | |||
| The number of hours in a day cannot exceed 24... | Excel Worksheet Functions | |||
| Change colour of Text if number in cell exceed limit | Excel Worksheet Functions | |||
Hybrid Mode
