If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Importing from Peoplesoft
Dear Colleagues,
I am importing a file from Peoplesoft into Excel 2003. There is a green triangle in each cell. I tried to change to format to General, so that I could use a formula to copy the last five digits to the next column. For some reason the text will not right align. When I tried to copy/paste the imported data via the Taskpane to another part of the spreadsheet, the green trianangles disappeared and the formula worked. But this is cumbersome. Does anyone have any ideas on changing the formatting without going through the copy/paste routine?In fact if I use Ctrl C and Ctrl V, then the green triangles appear. I only works by using the Taskpane which is inconvenient. Thanks. Louis Excel 2003 User |
Thread Tools | |
Display Modes | |
|
|