EXCEL DIGITS being changed to ZEROS!!! HELP

[RobertYoung]

When I enter a number with 16 + didits in excel, it converts the 16th and higher digits to ZEROS! HELP!

 

[Mark W.]

On 2002-04-18 10:37, RobertYoung wrote:
When I enter a number with 16 + didits in excel, it converts the 16th and higher digits to ZEROS! HELP!

That's because Excel only supports precision to 15 digits. See the Excel Help Index topic for "limits in Microsoft Excel" and consult the "Worksheet and workbook specifications".

 

[RobertYoung]

Is there anything I can do, so that I can create a 16 digit #?

 

[Yogi Anand]

Hi Robert:
This question has also come up earlier ... and there was a pretty good discussion on this. I would suggest looking at the following thread also:

http://www.mrexcel.com/board/viewtopic.php?topic=3306&forum=2

Regards!

 

[Mark O'Brien]

Nope, that's why it's called a limit.

 

[Mark W.]

On 2002-04-18 10:48, RobertYoung wrote:
Is there anything I can do, so that I can create a 16 digit #?

Enter it as a text value (e.g., "1234567890123456"). If you're trying to enter an account or credit card number you should enter it as text anyway because you're not gonna perform arithmetic operations on 'em!!

Just format these cells as Text prior to data entry.

 

[RobertYoung]

Thanks all...looks like I'm limited to 15.

RY