| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Which the maximum of characters of value in a cell?
When I impute a numerical sequence in a cell with more than 15 digits, excel
does not conserve the typed value, modifying the digits from 16th typed. I ask: it is necessary to adjust some configuration in excel? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Which the maximum of characters of value in a cell?
Hi
Excel's numerical limit is 15 digits. If you need to use more than 15, you'll have to enter it as text - either by formatting the cell as text before you type into it, or by starting the entry with a ' Hope this helps. Andy. "Malisky" wrote in message ... When I impute a numerical sequence in a cell with more than 15 digits, excel does not conserve the typed value, modifying the digits from 16th typed. I ask: it is necessary to adjust some configuration in excel? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display text 1024 characters in a cell | Excel Worksheet Functions | |||
| Max number if characters in a merged cell | Excel Discussion (Misc queries) | |||
| remove last three characters of cell | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
| if cell starts with characters formula | Excel Discussion (Misc queries) | |||
Linear Mode
