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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
(e-mail address removed)12.mn.us
 
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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 15 max ?
|
| "Don Guillett" wrote:
|
| > 15 max
| >
| >
| > --
| > Don Guillett
| > SalesAid Software
| > (e-mail address removed)
| > | > >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
| > > (e-mail address removed)12.mn.us
| >
| >
| >
 
Back
Top