Forum Discussion
Lost data when save as .GLT file to .PRN file on excel
Lost data when I save as .GLT file to .PRN file on excel.
The process is as below.
1. make a excel file(aaa.xlsx) following as
| Reference | Date | Month | Acct | Description |
| 12926 | 122120 | 01 | 721.00 | USPS |
| 12930 | 122820 | 01 | 721.00 | USPS |
| 12932 | 011121 | 01 | 721.00 | USPS |
| 12933 | 011121 | 01 | 721.00 | USPS |
Save to "aaa.xlsx"
2. Change name aaa.xlsx to "aaa.GLT" on window file explorer.
3. open "aaa.GLT", save as "aaa.GLT.PRN"
after save as, some character lost following as
| 12926122120 721.00 USPS |
| 12930122120 721.00 USPS |
| 12932011120 721.00 USPS |
| 12933011120 721.00 USPS |
If transfer(GLT to PRN) worked properly, result should be
| 12926 12212001 721.00 USPS |
| 12930 12282001 721.00 USPS |
| 12932 01112101 721.00 USPS |
| 12933 01112101 721.00 USPS |
Space and middle of 2 digit(bold) missing.
In this case, How can I solve this data lost problem?
Thank you so much.
No RepliesBe the first to reply
