Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to enter more than 20 digit numbers in one cell
I want to add just 20 digit number in one cell but whenever I try to type 13080048062000000030 I get 13080048062000000000
What is the problem ? Presently I am just putting '13080048062000000030. It just forces it in text format but I have not solved the original problem. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to enter more than 20 digit numbers in one cell
You have 2 options:
You already know one of them Put an apostrophe (') in front of the number. That's OK for occasional use. The other is to set the number format for the range of cells to Text <format<cells<number tab Category: Text......Click [OK] Now whatever you type in the cells will be interpreted as text, including numbers and formulas. Does that help? *********** Regards, Ron XL2003, WinXP "Prasad.Sakharkar" wrote: I want to add just 20 digit number in one cell but whenever I try to type 13080048062000000030 I get 13080048062000000000 What is the problem ? Presently I am just putting '13080048062000000030. It just forces it in text format but I have not solved the original problem. -- Prasad.Sakharkar |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to enter more than 20 digit numbers in one cell
From
http://office.microsoft.com/en-us/ex...CH062527721033 (or from Specifications and Limits in Excel help): Number precision 15 digits Beyond that you need text (as you've discovered), and then use text manipulation if you need to do calculations. -- David Biddulph "Prasad.Sakharkar" wrote in message ... I want to add just 20 digit number in one cell but whenever I try to type 13080048062000000030 I get 13080048062000000000 What is the problem ? Presently I am just putting '13080048062000000030. It just forces it in text format but I have not solved the original problem. -- Prasad.Sakharkar |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Entering 16 digit numbers in cell | New Users to Excel | |||
can't enter a num. in xl cell, which is more than 16 digit or lon | Excel Discussion (Misc queries) | |||
how can I enter a 21 digit number in a cell & keep it from change | Excel Discussion (Misc queries) | |||
16 DIGIT NUMBERS IN CELL WITHOUT LAST DIGIT BEING A ZERO | Excel Worksheet Functions | |||
When we enter a 16 digit number (credit card) the last digit chan. | Excel Discussion (Misc queries) |