How to input numbers in excel without it calculating

[evonna_21]

I'm creating a spreadsheet which I need to input upc codes for products. Every time I type in upc numbers and press tab or enter. The numbers I've typed turn into decimal numbers. Is there a way excel can just let me input my numbers without it doing something to the numbers. I turned off automatic calculations thinking that may help but it didn't help my the numbers stay the same I typed. How can I stop excel from doing something to the numbers I type.

[Tony Valko]

Post some examples of what you type and what Excel does to it.

[sanram]

Select the range you working on. Then change the format to Text. That's it.

[evonna_21]

Awesome, this fixed my problem. Thanks.

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.