I am trying to enter serial numbers in a cell in the following format:
3256,5623,8965,8754
when I enter the info excel changes it to 325,656,238,965,875

Numbers are only precise to 15 digits

"Brent" wrote:

I am trying to enter serial numbers in a cell in the following format:
3256,5623,8965,8754
when I enter the info excel changes it to 325,656,238,965,875

Try entering it as text format the cell to text as opposed to number

"Brent" wrote:

I am trying to enter serial numbers in a cell in the following format:
3256,5623,8965,8754
when I enter the info excel changes it to 325,656,238,965,875

I have done this and it works but then I try to add another 4 digit number
using contatenate and the only thing that results in the cell is a formula.
Do you know how this can be fixed. thanks

"Pimamedic" wrote:

Try entering it as text format the cell to text as opposed to number

"Brent" wrote:

I am trying to enter serial numbers in a cell in the following format:
3256,5623,8965,8754
when I enter the info excel changes it to 325,656,238,965,875

The cell should calculate. Select it, then press F2 and then ENTER.
See if that helps. If it does not, go to the Tools menu, choose
Options, then the View tab. There, ensure that the "Formulas" item in
the "Window Options" section is NOT checked.


Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)'


On Wed, 1 Apr 2009 14:41:02 -0700, Brent
wrote:

I have done this and it works but then I try to add another 4 digit number
using contatenate and the only thing that results in the cell is a formula.
Do you know how this can be fixed. thanks

"Pimamedic" wrote:

Try entering it as text format the cell to text as opposed to number

"Brent" wrote:

I am trying to enter serial numbers in a cell in the following format:
3256,5623,8965,8754
when I enter the info excel changes it to 325,656,238,965,875

Thanks for the help

"Brent" wrote:

I have done this and it works but then I try to add another 4 digit number
using contatenate and the only thing that results in the cell is a formula.
Do you know how this can be fixed. thanks

"Pimamedic" wrote:

Try entering it as text format the cell to text as opposed to number

"Brent" wrote:

I am trying to enter serial numbers in a cell in the following format:
3256,5623,8965,8754
when I enter the info excel changes it to 325,656,238,965,875

Your best bet is to enter the data preceded by an apostrophe, as in:
'3256,5623,8965,8754

The apostrophe tells Excel you are entering text, so leave it alone.

Now you don't have to preformat your cells as text, so that when you enter a
formula, it will be accepted as one, and will display the results you are
looking for.

Regards,
Fred.

"Brent" wrote in message
...
I have done this and it works but then I try to add another 4 digit number
using contatenate and the only thing that results in the cell is a
formula.
Do you know how this can be fixed. thanks

"Pimamedic" wrote:

Try entering it as text format the cell to text as opposed to number

"Brent" wrote:

I am trying to enter serial numbers in a cell in the following format:
3256,5623,8965,8754
when I enter the info excel changes it to 325,656,238,965,875