I need to make a hardcopy printout of all my records for safekeeping in emergency. I have over 800 records. If I print from within SplashID, it only puts one record on a page, the font is large, there is a lot of wasted white space, and requires over 800 sheets of paper. If I only want to print one record, that is fine. But to print all 800+ it is ridiculous. I can print as pdf and then print 4 pages to one sheet and double sided – that will reduce my page count to 100 – but still impractical. Add ability to allow to customize printing with close spacing and font adjustable.
If I export as .csv file, many record fields contain number data (credit card number, phone number etc) that Excel converts to exponential notation. I can change format of whole sheet (all fields) to text and I can set excel to not show exponential format, but it doesn’t seem to work very well. Many numbers still are in exponential unless I open that field to recalculate and then close. I can’t go through all 800+ lines to check all numbers. Is there anyway to make sure number fields are exported as text to excel?