View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max
 
Posts: n/a
Default pasting zero '0' into excel, not loose the number 08459 to 8459

From your subject line ..
pasting zero '0' into excel,
not loose the number 08459 to 8459

Try pre-formatting the cell(s) / col as Text before copy pasting
(via: Format Cells Number tab Text OK)

P/s: Always enter your query within the message area (the whitespace), do
not leave the message area blank. The subject line is supposed to contain
just a key description of your query, not the entire post <g
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"diamonde" wrote in message
...