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