How can I keep leading 0's in pasted numbers?

G

Guest

I am pasting numbers into Excel. The numbers stand for the last two digits of
a year (i.e. 02, 03, 04). Excel likes to delete the leading 0 because it
thinks that I don't need it. How can I turn this "feature" off?

Thanks.
 
J

Jason Morin

Before you paste in the data, make sure the destination
cells in Excel are set to text (Format > Cells).

HTH
Jason
Atlanta, GA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I stop Excel from dropping leading zeros? 9
Keeping leading 0's 4
keeping leading 0's when formatting cells 3
Leading 0 in Mail Merge document 4
Leading zeros 9
how can I keep excel from suppressing leading zeros as text 3
Importing to Excel from csv AND keep leading zeros 2
part numbers auto-convert to dates 4

Top