Keeping the zero in front of a UPC number in excel?

Keeping the zero in front of a UPC number in excel?

I’m trying to format a file with UPC numbers in excel, some of which have zeros as the first number. I know how to get the zero to stay in front of the number in teh cell, but is there any way to have the zero show up in the formula bar? For example. the cell will say 039841401028, but the formula bar says 39841401028

Tags: , , , ,

Under Forum

2 Comments for Keeping the zero in front of a UPC number in excel?

  • 1. forcrynoutloud  |  February 15th, 2011 at 8:30 am

    Highlight the cell(s) right click the highlighted area >format >Number…choose either custom, general, scientific, text or special (Pretty much anything but number)

  • 2. Nahee_Enterprises  |  February 15th, 2011 at 9:09 am

    If you want it to show in the Formula Bar with leading zeroes, then do not make the cells formatted as Numbers. Make them just plain Text formats. then you can put what ever you want as values and they will display that way in the Formula Bar.

Leave a Comment for Keeping the zero in front of a UPC number in excel?

You must be logged in to post a comment.

Trackback this post  |  Subscribe to the comments via RSS Feed

Categories