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
Report in Excel
-
- Posts: 132
- Joined: Sun Apr 02, 2006 10:36 am
- Location: Pakistan
Who is online
Users browsing this forum: No registered users and 9 guests