Open the CSV file with MS Word or Notepad.
Select All, Copy. Paste into Excel.
Use the Text to Columns... feature to separate the columns, being careful to set the format of columns with leading zeroes to 'Text'.
Tom
Need to export a report in CSV format and convert it to Excel. Only problem is the leading zeros on either Lookup Codes or Aliases are dropped. Tried using Tab Delimited but we have a lot of items with long extended descriptions so that causes problems. CSV keeps the columns clean. Anyone know of a way to open a CSV file in Excel and have the leading zeros stay.
Thank you, Neil
Thank you for the quick reply Tom. This is what I have been doing. I just was hoping that there was a simpler way. This process is hard for my employees to grasp.
Thank you again. Neil
"Terrible Tom" wrote:
hi run the report there is button "copy as table" go and load the new excel file and just paste it, i belive this will solve your issue.
Akber
"nt8378" wrote:
Copy as table & paste into Excel will not retain leading zeros unless the Excel column(s) where the leading zeros will be are formatted as TEXT and you use Paste Special... Values Only.
Tom
Akber Alwani,
This works great. I set Excel to open all cells as Text instead of General. And now when I use the copy to table and paste it to Excel it looks perfect. All leading zeros are there. Thank you for the great tip.
Thanks again, Neil
"Terrible Tom" wrote:
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.