Re: Excel assumes too much

From: Always Learning (NoMoreSpam_at_MyEmail)
Date: 06/23/04 

Date: Wed, 23 Jun 2004 15:53:35 +0100

Hi Jim,

I tried your suggestion but 17-Dec gets converted to 38338
Do you have any other ideas.

Thanks,

Steve Wilson.

"Jim Rech" <jrrech@hotmail.com> wrote in message
news:uzO%23d6QWEHA.2908@TK2MSFTNGP10.phx.gbl...
> The OpenText method allows you to specify the data type of each field.
You
> would have to specify that this field is text.
>
> To see how this is done first temporarily change the file's extension to
TXT
> (just so long as it is not CSV). Then record a macro as you open the file
> in Excel. The File Import Wizard will appear and you use the third screen
> of the wizard to change the field type of the "date" field to Text from
> General.
>
> The resulting macro will demonstrate using the FieldInfo parameter to
> control data type.
>
>
>
> --
> Jim Rech
> Excel MVP
> "Always Learning" <NoMoreSpam@MyEmail> wrote in message
> news:e$W7FMQWEHA.2716@tk2msftngp13.phx.gbl...
> | Hi There,
> |
> | I have a procedure that imports a .csv file.
> | All was going well until some of the cell values being imported were
> 17DEC,
> | 28DEC and that made Excel think they are dates and puts into the cell
> 17-Dec
> | & 28-Dec, which is wrong, these are actually stock codes.
> | How do I make sure that when I am processing the data that it stays
> exactly
> | as it is in the .Csv file.
> | Do I have to format the column to be Text before hand? When I tried that
> it
> | changed 17DEC into something like 38334
> |
> | Any help or advice would be appreciated.
> |
> | Best Regards,
> |
> | Steve Wilson.
> |
> |
>
>

Relevant Pages

  • Re: Big numbers
    ... entire query; they only implement part of it. ... specify the data type to use, before you can get data in a data type ... I've been talking about queries in general, not specifically ANSI SQL ...
    (comp.lang.c)
  • Re: Why in stdint.h have both least and fast integer types?
    ... There is no point making a data type "fast" if it is to be ... exactly 16 bits and another that behaves as if it has at least 16 bits. ... wouldn't prefer to specify that array as int16_t. ... architecture of the underlying machine (in this case, primary cache size) ...
    (comp.lang.c)
  • Re: Need help converting a Sined field
    ... if you are wanting the DATA TYPE of the resulting colum to be specified, you can use a data conversion function such as ... once the properties window is showing, you can type a format for your number by clicking in the appropriate column and filling the format property (if you choose from the drop-list, you can also specify the Decimal property -- specifying Decimal without Format has no effect). ... Just need a query or a way to convert the sined field into a large interger. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Base Data Type vs Data Type in Field Node Property
    ... when to use Data Type. ... I mean should I specify ... > the Data Type property too when I have specified the Base Data Type? ... the element definition, and then gives it an anonymous type that inherits ...
    (microsoft.public.biztalk.general)