How do I keep numbers from rounding in a custom format?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

daisyweg - 09 Nov 2006 16:11 GMT

I need to enter 17 digit account codes into a spreadsheet. the format I set
up to do this was including the hyphens that spearate various factors within
the account codes. However, when I enter the numbers, the last digit is
rounding down and I need it to stay the way I enter it. My limited
experimenting included formating the cells as text, but then I was forced to
entere all the hyphens. Following is the format I created.

##-###-###-###-###-###

Thank you for any help you can offer. PLease respond to
d.wegner@komets.k12.mn.us

Reply to this Message

Don Guillett - 09 Nov 2006 16:22 GMT

15 max

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

>I need to enter 17 digit account codes into a spreadsheet. the format I set
> up to do this was including the hyphens that spearate various factors
[quoted text clipped - 9 lines]
> Thank you for any help you can offer. PLease respond to
> d.wegner@komets.k12.mn.us

Reply to this Message

daisyweg - 09 Nov 2006 16:31 GMT

15 max ?

> 15 max
>
[quoted text clipped - 11 lines]
> > Thank you for any help you can offer. PLease respond to
> > d.wegner@komets.k12.mn.us

Reply to this Message

Niek Otten - 09 Nov 2006 16:57 GMT

Excel's numerical precision is 15 decimal digits.
For identifiers, like credit card numbers, use text.
Two ways (at least):
a. Format the cell as text before entering the "number"
b. Precede the entry with an apostrophe; it will not show, but force the entry to be text

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| 15 max ?
|
[quoted text clipped - 13 lines]
| > > Thank you for any help you can offer. PLease respond to
| > > d.wegner@komets.k12.mn.us

Reply to this Message