Viewing bills offline

smh · Post by **smh** » Tue Jun 25, 2002 12:01 pm

emmem wrote:CSV means Comma Separated Value(s).

Ah, stupid me, could have thought about that myself. Thought it was a default extension for some kind of database program.

emmem · Post by **emmem** » Tue Jun 25, 2002 8:53 pm

smh wrote:
emmem wrote:CSV means Comma Separated Value(s).
Ah, stupid me, could have thought about that myself. Thought it was a default extension for some kind of database program.

Well, if I want to know what a certain file extension or an abbreviation means I always look it up with acronymfinder

Guest · Post by **Guest** » Tue Jun 25, 2002 9:00 pm

If I load the csv-file into Excel, I have all the notes on the same line. How can I make it so the banknotes are correctly under each other?

avij · Post by **avij** » Tue Jun 25, 2002 9:08 pm

Anonymous wrote:If I load the csv-file into Excel, I have all the notes on the same line. How can I make it so the banknotes are correctly under each other?

You need to open the file by selecting File->Open from Excel, just remember to select the correct file type from the pulldown list. If you doubleclick on the file to open it, the columns won't be aligned properly as you've seen. Strange but true..

smh · Post by **smh** » Tue Jun 25, 2002 10:32 pm

Goto data/text to collumns to get everything into collums.

Even easier is to record a macro once