http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Thu, 14 May 2026 15:35:01 +0000 Fri, 06 Jan 2012 00:34:13 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=19353 http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ http://forum.codejock.com/forum_posts.asp?TID=19353&PID=67339&title=column-format#67339 Author: yfphang
Subject: 19353
Posted: 06 January 2012 at 12:34am

Thank for reply,
currently i am using below code to manual convert last column to decimal point, i found that is to troublesome, just to find out any other quick way to do it.
i am using classic Visual Basic 6.0

my code
With DataLst
.Columns(.Columns.Count - 1).HeaderAlignment = xtpAlignmentRight
.Columns(.Columns.Count - 1).Alignment = xtpAlignmentRight

For k = .Columns.Count - 1 To .Columns.Count - 1
    For i = 0 To .Rows.Count - 1
            xx = Format(.Records(i).Item(k).Caption, "#0.00")
           .Records(i).Item(k).Caption = xx
    Next i
Next k

End With]]> Fri, 06 Jan 2012 00:34:13 +0000 http://forum.codejock.com/forum_posts.asp?TID=19353&PID=67339&title=column-format#67339 http://forum.codejock.com/forum_posts.asp?TID=19353&PID=67328&title=column-format#67328 Author: Xander75
Subject: 19353
Posted: 04 January 2012 at 5:41am

Hi,

Try formatting the value using "FormatNumber(value, 2)", this is Visual Basic 6 code.

Please add a signature saying what language(s) you are using as it will help with responses.
]]> Wed, 04 Jan 2012 05:41:26 +0000 http://forum.codejock.com/forum_posts.asp?TID=19353&PID=67328&title=column-format#67328 http://forum.codejock.com/forum_posts.asp?TID=19353&PID=67278&title=column-format#67278 Author: yfphang
Subject: 19353
Posted: 24 December 2011 at 6:00am

Hi, How to change all to column with format "0.00"

Thank.

]]> Sat, 24 Dec 2011 06:00:29 +0000 http://forum.codejock.com/forum_posts.asp?TID=19353&PID=67278&title=column-format#67278