Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I paste ISBN numbers into excel and keep the leading zero?
I need to copy data from an HTML table, which includes ISBN and ISSN numbers,
and paste it into Excel. My problem is that I cannot get Excel to recognise the leading zeros in the ISBN/ISSNs. Excel formats it as a number as soon as it is pasted in. If I then select the column with the number in and re-format it as text, the leading zero does not appear. If I copy and 'paste as text' into excel, of course the data does not appear in seperate columns. I've read the advice already in existence on this subject but it doesn't address my particular problem - I'd be grateful for any help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I paste ISBN numbers into excel and keep the leading zero?
Hi
Try formatting the columns as Text in Excel, *before* pasting that data -- Regards Roger Govier "darkbagpuss" wrote in message ... I need to copy data from an HTML table, which includes ISBN and ISSN numbers, and paste it into Excel. My problem is that I cannot get Excel to recognise the leading zeros in the ISBN/ISSNs. Excel formats it as a number as soon as it is pasted in. If I then select the column with the number in and re-format it as text, the leading zero does not appear. If I copy and 'paste as text' into excel, of course the data does not appear in seperate columns. I've read the advice already in existence on this subject but it doesn't address my particular problem - I'd be grateful for any help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|