J JAYLO Board Regular Joined Apr 3, 2002 Messages 237 Sep 20, 2006 #1 All - I have a field in a table that is an 11 character number. The trouble is I am dropping leading zero's. Is there a way to handle this? Ex: 0005679790 shows as 5679790 which is not acceptable.
All - I have a field in a table that is an 11 character number. The trouble is I am dropping leading zero's. Is there a way to handle this? Ex: 0005679790 shows as 5679790 which is not acceptable.
Joe4 MrExcel MVP, Junior Admin Joined Aug 1, 2002 Messages 55,457 Office Version 365 Platform Windows Sep 20, 2006 #2 If you have the field formatted as Text instead of a Numeric option, the leading zeroes will not be dropped.
If you have the field formatted as Text instead of a Numeric option, the leading zeroes will not be dropped.