Forum Discussion

Anonymous's avatar
Anonymous
Aug 10, 2021

Is it possible to keep leading zeroes for pasted numbers?

Is it possible to retain leading zeroes in pasted numbers. I read through Microsoft's help steps and their solution to format as text does not work. These are UPC codes and I don't see any way of keeping the number as is, even when formatting as a number before or after pasting. Any help appreciated.

excel

4 Replies

  • Pete61's avatar
    Pete61
    Copper Contributor
    Dec 01, 2021
    Yes, the help doesnt work for me too. It suggests using special and then tagging it as a phone number, but Excel doesn't allow that. Why is it so difficult to paste a number of phone numbers?
  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Aug 11, 2021
    Where are you pasting them from? Have you tried paste special, Values after formatting the area as text? If you want to keep the numbers as numbers, but display leading zeroes, format the cell as custom using 00000000 as format string (as many zeroes as the number of digits you have)
  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Aug 11, 2021

    If you’re looking to ask a question or start a conversation about Excel, you’re in the right place.

     

    Please include the following info to help others answer your question:

    Welcome to your Excel discussion space!

     

    Thank you for your understanding and patience

     

    Nikolino

    I know I don't know anything (Socrates)