Text Format in Excel using VBA

views:

answers:

+1 Q:

Text Format in Excel using VBA

Hi,

When I use WinSQL to run a SQL statement, the result is 20100803000001812. However, when I incorporate the SQL as a macro, the result is 2.01008E+16. What should I do in the macro in order to maintain the result as 20100803000001812 ?

Thanks,

Bob

According to this article ActiveCell.NumberFormat = "@" should do the trick.

BenV 2010-10-02 21:19:03

Bob 2010-10-03 06:02:10

As suggested by Tahbaza on 4 Oct 2010, an apostrophe if you're just wanting the column to display as text, something like :- select Cno,Itno,CONCAT('''',Ref) as Ref from test.

Bob 2010-10-07 03:01:34

ActiveCell.NumberFormat = "0" works for me (not what I expected, but so it goes)

You might want to throw in a Cells.Columns.AutoFit to resize the columns as necessary.

variant 2010-10-03 19:29:07

Nope, it's still shows as 2.01008E+16.

Bob 2010-10-04 01:40:53

@Bob - Where are you putting this code in? What if you try setting the number format manually?

variant 2010-10-04 11:23:10

Bob 2010-10-05 02:24:16

@Bob good that you got it figured out. You should post the solution and accept that as your answer to close out the question.

variant 2010-10-05 04:03:15

ansaurus

tags:

views:

answers:

Text Format in Excel using VBA

related questions