Hi All, > > Well, you set the string of a cell. > Set the formula instead.
So I just started from scratch because I had a ton of if statements before, decided to go to switch to make it faster but I'm hitting the same type of problem. Document: https://drive.google.com/file/d/0B5S-XtOUGGH5UmpBdnIzUUM3OFE/view?usp=sharing Click "Create Ledger" and you'll see the macro begin. Problem: Look at sheet "Ledger" under header "Date" (B7:B10). At first I thought those were right but they are not. Convert those to date, you'll see that all of them are 12/10/14. I literally have no clue where those are coming from. They should be: B7: 06/26/2009 B8: 06/26/2009 B9: 06/27/2009 B10: 06/28/2009 (all taken from RawData sheet). If you look at the macro (Sub fillData) you'll see that the pasteValue gets Date(year,month,date), furthermore you can see that year, month, date all get the correct values (uncomment the "print" values in the switch)..... Terribly confused at this point, suggestions welcome. Best, Joel -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted