| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retain original invoice format
Hi all,
I use Able2Extract to convert a report from .pdf to .xls I then have some code to pull units and invoices to Columns A and B respectively The invoice is coming in Column B as 1 or 2 lets say, but the original format in these cases is 001 and 002 There are many differnet scenarios, every vendor is different Samples: INV001 CM001 001 INV-001 89765434 etc.. I need to be able to handle all scenarios without really knowing in advance what the field may contain Any guidance? Thanks! -goss |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Retain original invoice format
In Able2Extract, is there a functionality to bring every field in as text?
If so, that would solve your problem. -- --Thomas [PBD] Working hard to make working easy. Answered your question? Click ''Yes'' below. "-goss" wrote: Hi all, I use Able2Extract to convert a report from .pdf to .xls I then have some code to pull units and invoices to Columns A and B respectively The invoice is coming in Column B as 1 or 2 lets say, but the original format in these cases is 001 and 002 There are many differnet scenarios, every vendor is different Samples: INV001 CM001 001 INV-001 89765434 etc.. I need to be able to handle all scenarios without really knowing in advance what the field may contain Any guidance? Thanks! -goss |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transpose data and retain links to original data | Excel Worksheet Functions | |||
| retain value and delete format | Excel Worksheet Functions | |||
| Change number of decimals but retain original style | Excel Discussion (Misc queries) | |||
| Retain date format in cell | Excel Discussion (Misc queries) | |||
| Retain Original Date in Page Header | Excel Programming | |||
Linear Mode
