Re: Cell formatting issue

On May 16, 4:04 pm, "Peo Sjoblom" <terr...@xxxxxxxx> wrote:
If you use a web query you can pre-formatthe columns as text and then in
the query process (under properties) select Preserve cell formatting

--
Regards,

Peo Sjoblom

<Richard.Bri...@xxxxxxxxxx> wrote in message

news:1179340808.598621.86160@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx



On May 16, 11:53 am, CLR <C...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Yes, usually in the Importing Utility.............how are you bringing
the
data in toExcel?.......If through MSQuery you can just follow the menus
and
should see the option toformateach field.

Vaya Con Dios,
Chuck, CABGx3

"Richard.Bri...@xxxxxxxxxx" wrote:
On May 16, 9:38 am, CLR <C...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
If you don't have to do any math on the figures, you might try
importing that
column as TEXT, to get it to display all the numbers....

Vaya con Dios,
Chuck, CABGx3

"Richard.Bri...@xxxxxxxxxx" wrote:
Hello,

We have data that is downloaded to a .xls file from a SAP
application.
The field in question is a 30 character field that contains all
numeric data. The problem is when opened inExceltheformatof the
data is change to scientific notation and the right 7 characters
are
changed to zeros. The character string should be
9611019049526870545643 but inExcelit appears as 9.61102e+21 and
formated as a general number. When converted to a displayable
number
it converts to 9611019049526870000000. I tried saving the file
rather
than opening it intoExceland found the character string did
contain
all the numbers, when opening it in Notepad it appears as
<td class='SAPBExSt' style=" "> 9611019049526870545643 </td>.

Any assistance would be appreciated.

Thanks,

Rick- Hide quoted text -

- Show quoted text -

Chuck,

Thank you for your response. Is there a way to specify the field's
importformat?

Thanks,

RIck- Hide quoted text -

- Show quoted text -

Unfortunately the file is already a .xls file andExceldoes not
recoginize the need to run the import wizard to open the file. It is a
download from a SAP Web query. I did check the .xls file and the
string is all there beforeExcelopens it and changes it. I tried
cutting and pasting a long numeric string into anExcelcell and
experienced the same results.

Is there a way to override the 15 char limit inExcelor to treat the
string as a string and not a number?

Thanks,

Rick- Hide quoted text -

- Show quoted text -

Thank you for the response but I don't see where I have the control to
specify the maintian cell formatting. In testing I have a situation
where one value is truncated into the scientific notation and the
other is not. Looking at the .xls file I do not see a difference
between the two character strings that would cause one to truncate and
the other to open correctly. Any thoughts?

.

Relevant Pages

  • F is evil (was: XML::LibXML UTF-8 toString() -vs- nodeValue())
    ... And with C<use encoding 'utf8';> you'll get the same character string, ... A script is the complete program text, ...
    (comp.lang.perl.misc)
  • Re: Question about Descriptors
    ... > let you effortlessly do math with numbers that were stored in strings. ... If you moved a character string with numeric characters ... I think I missed the posting that defined string processing. ... String processing includes a native ability to define character string variables ...
    (comp.os.vms)
  • Re: Error when creating menu item on command bar
    ... It runs fine when run from an .xls file. ... Dim cWmb As String, cMm As String ... Dim MenuName As String ... 'To delete any existing Utilities menus ...
    (microsoft.public.excel.programming)
  • Re: Why character instead of numerics?
    ... Create Cursor Test ) ... > numeric (not numeric digits in a character string that looks like a ... if I decode a character string that is composed of various digits ...
    (microsoft.public.fox.vfp.queries-sql)
  • Re: Can somebody point me in the right direction?
    ... ten from the ten character string. ... There should be little probability of entering a random character string ... If you use encryption you have a potential problem at the second black ...
    (sci.crypt)