Hello,

I need some help with an issue displaying numeric amounts as numbers
in excel.

what I have in the report file:
- report dataset exposing decimal(20,5) fields
- report cells with Format=N Language=French

what I have in web and excel result:
- correct displayed format (thousands separator and 2 decimal
precision)

my issue:
in excel, the amount cells are displayed with a warning: 'Number
Stored as Text'

What is the correct setting for excel to understand my numeric amounts
as number (so I can make computations without applying formatting
manually after the export)?

Thanks

Gauthier Segay

Gauthier,

How are you formatting the number? Based on your problem I suspect that you
are using the Format method in the expression for the value of the text box.
The issue is that method returns a string not a number, so Excel sees the
value as a string.

If you instead use the Format Code property for the textbox and enter your
formatting there, then it will accurately be represented in Excel as a
number. In this case the value of field is going to be a number so Excel
treats it accordingly.

Let me know if you need more info,
Andrew Karcher
SQL Server MVP

<newsgroup.poster (AT) gmail (DOT) com> wrote

Gauthier,

How are you formatting the number? Based on your problem I suspect that you
are using the Format method in the expression for the value of the text box.
The issue is that method returns a string not a number, so Excel sees the
value as a string.

If you instead use the Format Code property for the textbox and enter your
formatting there, then it will accurately be represented in Excel as a
number. In this case the value of field is going to be a number so Excel
treats it accordingly.

Let me know if you need more info,
Andrew Karcher
SQL Server MVP

<newsgroup.poster (AT) gmail (DOT) com> wrote

Gauthier,

How are you formatting the number? Based on your problem I suspect that you
are using the Format method in the expression for the value of the text box.
The issue is that method returns a string not a number, so Excel sees the
value as a string.

If you instead use the Format Code property for the textbox and enter your
formatting there, then it will accurately be represented in Excel as a
number. In this case the value of field is going to be a number so Excel
treats it accordingly.

Let me know if you need more info,
Andrew Karcher
SQL Server MVP

<newsgroup.poster (AT) gmail (DOT) com> wrote

Gauthier,

How are you formatting the number? Based on your problem I suspect that you
are using the Format method in the expression for the value of the text box.
The issue is that method returns a string not a number, so Excel sees the
value as a string.

If you instead use the Format Code property for the textbox and enter your
formatting there, then it will accurately be represented in Excel as a
number. In this case the value of field is going to be a number so Excel
treats it accordingly.

Let me know if you need more info,
Andrew Karcher
SQL Server MVP

<newsgroup.poster (AT) gmail (DOT) com> wrote

Gauthier,

How are you formatting the number? Based on your problem I suspect that you
are using the Format method in the expression for the value of the text box.
The issue is that method returns a string not a number, so Excel sees the
value as a string.

If you instead use the Format Code property for the textbox and enter your
formatting there, then it will accurately be represented in Excel as a
number. In this case the value of field is going to be a number so Excel
treats it accordingly.

Let me know if you need more info,
Andrew Karcher
SQL Server MVP

<newsgroup.poster (AT) gmail (DOT) com> wrote

Gauthier,

How are you formatting the number? Based on your problem I suspect that you
are using the Format method in the expression for the value of the text box.
The issue is that method returns a string not a number, so Excel sees the
value as a string.

If you instead use the Format Code property for the textbox and enter your
formatting there, then it will accurately be represented in Excel as a
number. In this case the value of field is going to be a number so Excel
treats it accordingly.

Let me know if you need more info,
Andrew Karcher
SQL Server MVP

<newsgroup.poster (AT) gmail (DOT) com> wrote

Gauthier,

How are you formatting the number? Based on your problem I suspect that you
are using the Format method in the expression for the value of the text box.
The issue is that method returns a string not a number, so Excel sees the
value as a string.

If you instead use the Format Code property for the textbox and enter your
formatting there, then it will accurately be represented in Excel as a
number. In this case the value of field is going to be a number so Excel
treats it accordingly.

Let me know if you need more info,
Andrew Karcher
SQL Server MVP

<newsgroup.poster (AT) gmail (DOT) com> wrote

Gauthier,

How are you formatting the number? Based on your problem I suspect that you
are using the Format method in the expression for the value of the text box.
The issue is that method returns a string not a number, so Excel sees the
value as a string.

If you instead use the Format Code property for the textbox and enter your
formatting there, then it will accurately be represented in Excel as a
number. In this case the value of field is going to be a number so Excel
treats it accordingly.

Let me know if you need more info,
Andrew Karcher
SQL Server MVP

<newsgroup.poster (AT) gmail (DOT) com> wrote

Gauthier,

How are you formatting the number? Based on your problem I suspect that you
are using the Format method in the expression for the value of the text box.
The issue is that method returns a string not a number, so Excel sees the
value as a string.

If you instead use the Format Code property for the textbox and enter your
formatting there, then it will accurately be represented in Excel as a
number. In this case the value of field is going to be a number so Excel
treats it accordingly.

Let me know if you need more info,
Andrew Karcher
SQL Server MVP

<newsgroup.poster (AT) gmail (DOT) com> wrote