pre-formatting Excel Cells

Hi guys I was wondering whether it was possible to format a Cell in Excel before I actually display the data. The trouble I am getting at the moment is that a value that I am displaying in Excel is too large and presents an error. I could resolve this by formatting the cell to number. Is there anyway of doing this before I get into Excel?

Many thanks

Pent

[375 byte] By [P[e]ntium^] at [2007-11-11 8:18:17]

«« Tracing (urgent)
»» Please! this is driving me nuts (beginner)

# 1 Re: pre-formatting Excel Cells

There's a good article on DeveloperFusion that explains it easily,

Formatting Excel in VBA ( http://www.developerfusion.co.uk/show/35/7/)

Good luck,

msanchez at 2007-11-11 17:25:44 >

# 2 Re: pre-formatting Excel Cells

I solved the problem by placing a:

before printing the variable out to the screen which converts it into a string value.

P[e]ntium^ at 2007-11-11 17:26:43 >

This is a Technology portal site for all the developer, It's a community, here you can post your question when you are learning, working, and soso...we'll make it better than yesterday Everyday...

pre-formatting Excel Cells

Developer Tech

All Classified

Developer Tech New Topic

Developer Tech Hot Topic