Hello!

I have to work with a tool to export data from an oracle database to *.txt,
*.html or *.xls. HTML and TXT are working fine but in Excel I have problems
concerning numerical values. A number 1234.56 will appear as 123456 or
123456.00. As a workaround I can press F2 (edit cell) and then ENTER which
is like a substitution by itself. The value will be correct then. (But in
tests this worked only with a non-saved file.) As a workaround I tried to
write a vba routine (like: x=cell.value, cell.value=x) but this didn't work
either.

Can anybody help me on this topic?

Thanks in advance!
Peter

Peter,

It's probably just a formatting issue. Excel loves to format your columns
for you. Check out www.smokeylake.com/excel/textfiles.htm. Read about
opening and importing text files.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Peter Baute" <(E-Mail Removed)> wrote in message
news:chqdqd$7gr$01$(E-Mail Removed)...
> Hello!
>
> I have to work with a tool to export data from an oracle database to
*.txt,
> *.html or *.xls. HTML and TXT are working fine but in Excel I have
problems
> concerning numerical values. A number 1234.56 will appear as 123456 or
> 123456.00. As a workaround I can press F2 (edit cell) and then ENTER which
> is like a substitution by itself. The value will be correct then. (But in
> tests this worked only with a non-saved file.) As a workaround I tried to
> write a vba routine (like: x=cell.value, cell.value=x) but this didn't
work
> either.
>
> Can anybody help me on this topic?
>
> Thanks in advance!
> Peter
>
>