I am copying data from a SQL database into an excel ss. I must preformat the
cells of the ss that the data is being pasted to. This method still does not
keep the leading zeros. I am trying to eliminate the need to retype 4000+
numbers. Any suggestions?

"Dave Peterson" wrote:

preformat the cell as text and type all the 0's and hyphens

(or start your entry with an apostrophe:
'001-00234-00012-123


Jackie Kohlman wrote:

I need to keep the leading zeros and the hyphens. Is there a way to do this?

"Peo Sjoblom" wrote:

Excel has only 15 digits precision so you can't use that as a numericial
format

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Jackie Kohlman" <Jackie wrote in message
...





--

Dave Peterson