LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Cell formatting when pulling into VB


I have an excel spreadsheet that im pulling into a VB flexgrid wit
ADODB.

But i have a collumn that has a header and sub header and then belo
that is several records of times.
When it pulls from that table, it formats EVERYTHING in that collumn a
a time thus nullifying the header and sub header.

I tried adding 'imex=1' to the extrended proporties but then "2:00 PM
becomes .58333333...

is there a happy medium? some way i can have each cell formatte
individually

--
Skeletonha
-----------------------------------------------------------------------
Skeletonhat's Profile: http://www.excelforum.com/member.php...fo&userid=1569
View this thread: http://www.excelforum.com/showthread.php?threadid=27223

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pulling data from one cell to another Ivan Koh[_2_] Excel Discussion (Misc queries) 3 May 4th 09 06:53 PM
pulling data and formatting [email protected] Excel Discussion (Misc queries) 1 August 22nd 07 05:03 PM
Pulling text from a cell jnasr Excel Worksheet Functions 3 November 9th 06 04:44 PM
Pulling a Letter from a cell and filling another cell with info nick s Excel Worksheet Functions 16 November 28th 05 04:10 AM
pulling certain data out of a cell D richardson Excel Worksheet Functions 6 May 13th 05 06:10 PM


All times are GMT +1. The time now is 12:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"