Re: Excel number length-max length.

Hi,

All the numbers in Excel are kept as a 8-byte doubles. Hard to say what you
get. It is possible that Excel defined it as a string, not a number and in
this case you could get some sort of formatted string.

--
Val Mazur
Microsoft MVP

http://xport.mvps.org



"SP" <SP@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AF90C187-AF0D-4861-8C5D-735F8723C9FA@xxxxxxxxxxxxxxxx
> If I have a number more than 16 digits in a cell in excel and then when
> brought to VB through ADO, I get some different weird value. Does any one
> of
> you know the reason? And can give some links to msdn or somewhere where
> the
> max size is formally specified.
> Thanks,
> Sachin.
>


.

Relevant Pages

  • Re: Need help with SeriesCollection Object Please !
    ... Well Peter your explanation of my questions make sense and are sound answers. ... You seem very experienced with Excel and VBA:) ... Function GetSourceSheet(sFmla As String, sWSname, sFile As String) As ... ran my code on certain other charts sometimes it would return ...
    (microsoft.public.excel.programming)
  • Re: Format Excel - Object required error
    ... tell excel to autofit the columns. ... Public Sub FormatXLReport(strPath As String, ... Dim blnExcelExists As Boolean ... Private Const SW_SHOWNORMAL = 1 ...
    (microsoft.public.access.modulesdaovba)
  • Re: XP and string paths
    ... > the "Lcase" function is suddenly no longer available to Excel? ... > that occurs because of Windows XP. ... > string functions that Excel uses has become ... > is the usual "missing reference" problem. ...
    (microsoft.public.excel.programming)
  • RE: Issue with UNC Path (I think). Trying to build Dynamic Report
    ... Dim strBroker As String ... You may just have to determine the UNC path, ... Table and then suck in all the data from my Excel sheet on the network drive. ...
    (microsoft.public.access.formscoding)
  • Re: Opening Excel from Access
    ... Tried changing it to an MDB but no luck. ... Dim MDBName As String, DefaultDirectory As String, SQLStg As String ... .RefreshStyle = xlOverwriteCells ... comes when I click the button on Access form to show the Excel file. ...
    (comp.databases.ms-access)