Other Help Topics :: SIAG dates
Using DSL 3.0.1.
Having problem entering dates when using SIAG. The year reverts to 1969.
Tried different formats when entering ie., 12/31/2006 2006/12/31, 12.31.2006 etc to no avail.
What am I doing wrong?.
Too bad nobody responded to this; I just noticed the same thing.
The only solution I found was to enter the date as a label (i.e., May 20, 2007).
EDIT: I just figured it out; use the menu under "Data" for entering date, and use mm/dd/yy format.
Thanks jpeters,
I figured it out through trial and error.
www.siag.nu/siag has a lot of info but not very helpful on the basics.
Haven't figured out how to retain column formats (default, fixed etc) from column to column without using mouse to change each cell.
Hi John,
Block out an area, format, and save....should work, although I had to
do it twice initially to clear prior formating from individual cells. I stopped formating entire columns when I found it increased loading time substantially. (i.e, loading formating for hundreds of unused lines).
Now if I could just find a way to have Siag import in formulas from other formats instead of just labels, I'd love this spreadsheet....
Hi jpeters,
I too like SIAG.
I noticed it does not require the equal sign when entering a formula.
I use it as a checkbook register so my columns have different formats.
I've been entering similar format entries at one time, ie. defaults then fixed then dates.
A little slower but it works.
Block "Smart fill" only seems to work on two cells at a time, when used to adjust balance instead of retyping formula.
Did you check out the web site?
Regards.
Next Page...
original here.