Number Formats

B

Brent

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
 
B

Brent

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
 
C

Chip Pearson

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)'
 
B

Brent

Thanks for the help

Brent said:
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
Click to expand...
 
F

Fred Smith

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.
 
Top