Reply to what?

Both responders...Pete and Ryan......have explained Excel's treatment of numbers
with greater than 15 digits.


Gord Dibben MS Excel MVP

On Thu, 07 Apr 2011 06:45:53 GMT, sankar adhikary wrote:

please give reply

On Thursday, December 03, 2009 4:44 PM Julie wrote:

I am working with account numbers that have more than 15 digits. I am
working with office 2003 and after the 15 numbers it automatically makes the
numbers I enter a zero. I cannot format the column to text for another reason,
does anyone know how I can format that cell to show all 20 numbers that I
enter in one cell?

Thanks!!


On Thursday, December 03, 2009 5:44 PM Pete_UK wrote:

The only way you can retain all 20 digits is to treat the number as
text. If you cannot format the cell to Text beforehand, then you can
enter the number with a preceding apostrophe, like so:

'01234567890123456789

The apostrophe will not show in the cell, but Excel will treat it as a
text value.

Hope this helps.

Pete

the
son,


On Thursday, December 03, 2009 9:41 PM ryguy7272 wrote:

http://office.microsoft.com/en-us/ex...366191033.aspx

Once you convert numbers to text you cannot perform calculations on that text.

Good luck,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Pete_UK" wrote:


On Friday, December 04, 2009 4:41 AM Pete_UK wrote:

it is quite rare to need to perform calculations on account numbers.

Pete

wrote:
ext.
.
am
kes the
reason,
at I