Dec 28, 2006 #1 BreffniK Technical User Apr 27, 2004 24 US Currently, my years display as follows: 2,006.00 How may I get them to display as 2006 Thanks!
Dec 28, 2006 #2 hilfy Active member Oct 31, 2003 2,564 US It appears that you're showing your year as a numeric field. If it's its own field on the report, you can right-click on it and format the number. If you're using ToText, you can use a format parameter, something like this: ToText({year}, 0) -Dell A computer only does what you actually told it to do - not what you thought you told it to do. Upvote 0 Downvote
It appears that you're showing your year as a numeric field. If it's its own field on the report, you can right-click on it and format the number. If you're using ToText, you can use a format parameter, something like this: ToText({year}, 0) -Dell A computer only does what you actually told it to do - not what you thought you told it to do.
Dec 29, 2006 #3 lbass Technical User Feb 9, 2002 32,816 US With totext, you would want to make the formula: totext({table.year},0,"") ...to also remove the comma. -LB Upvote 0 Downvote
With totext, you would want to make the formula: totext({table.year},0,"") ...to also remove the comma. -LB