Column formatting help

Jeremy 123

New member
Joined
Oct 31, 2012
Messages
1
Reaction score
0
Points
0
Location
University Heights, Ohio, United States
I need to format a column to hold 12-digit upc codes. column A is custom formatted to 000000000000 which display my 11-digit string plus the beginning 0. now, when i try to copy and paste this column on column B and then save it, it reverts the whole column minus header from custom to text and deletes the beginning 0. what can i do?
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
Format column B the same way.
 
Top