Report in Excel
Posted: Thu Feb 12, 2009 8:15 am
I have an inventory report with the Excel as the ouput. One of the column is Part Number. The example of data like this
<pre id='pre'><font size=2>
In Oracle Table In Excel
Part Number Part Number
103-44555 103-44555
1122367 1122367
0541688 541688
</font></pre id='pre'>
The problems are:
1. How i can visible the '0' in Excel for the 0541688?. I try to add " ' " character but in excel the " ' " is display(so strange, right?) example: '0541688
2. How i can make the all the part number become left alignment(as char, not number)?
Thank you
<pre id='pre'><font size=2>
In Oracle Table In Excel
Part Number Part Number
103-44555 103-44555
1122367 1122367
0541688 541688
</font></pre id='pre'>
The problems are:
1. How i can visible the '0' in Excel for the 0541688?. I try to add " ' " character but in excel the " ' " is display(so strange, right?) example: '0541688
2. How i can make the all the part number become left alignment(as char, not number)?
Thank you