Thread: How do i prevent the 000's in the beginning of an entry from dropp
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bobby02169 bobby02169 is offline
external usenet poster
  
Posts: 24
Default How do i prevent the 000's in the beginning of an entry from dropp
I am trying to enter a combination of numbers and letters in a cell and if it
starts with a 0 (zero) when I hit enter to move to another cell all the 0's
at the beginning
drop off
EX: 0019301C76F5 becomes 19301C76F5

I need all 12 digits in order to sort the way i would like.
Is there a setting to prevent the 0 at the beginning from dropping?
Thank you for any help
Bobby
Reply With QuoteReply With Quote