| Number Conversion Fails in Excel [message #335850] |
Thu, 24 July 2008 00:31  |
paradoxkhan
Messages: 92
Registered: April 2008
Location: Pakistan
|
Member |
|
|
Hi All,
im transforming xml output to Excel
1)In excel numbers are converted to string, so cant perofrm any
calculation on numbers in excel....
anyone help me out
|
|
|
|
|
|
|
|
| Re: Number Conversion Fails in Excel [message #335946 is a reply to message #335933] |
Thu, 24 July 2008 04:06  |
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
|
Senior Member |
|
|
What I meant was that in general Oracle tools have a certain formatting in the front end (I don't know how that works in Reports, but I'm sure it can be done). First it looks at my own computer settings, if that's not set, then at the database. For example the (english formatted) number 1,004.3 will show up in Oracle Discoverer on my screen in Dutch like 1.004,3. If for some reason my Excel is set up in English, this will not be recognized as a number by Excel.
So, verify if your Excel settings are the same as the Oracle database and front end setting.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
