Format the cell as Text.

And paste directly into the formulabar

debbie wrote:

"nobby" wrote:

How do I show Leading Zero's in Excel

Hi,
here is my particular problem: I want to enter isbn's into my excel sheets.
Some start with 0 and some start with 1. If I select the column as 'text'
before entering any numbers, I have no problem. But if I copy and paste a
number from the order site, all of the isbns that start with zero lose the
leading zero upin the paste. Any ideas?

--

Dave Peterson