Kitto
|
Posted: 01/22/2004, 3:01 AM |
|
Hi,
Due to being in Europe, we use "," in our numeric values, for instance 10,2 while in most parts of word it is written with dot, i.e. 10.2 .
So I need solution to replace comma with dot so that when grid results exported to excel, they should recoginze as numeric values.
Thanks.
Kitto
|
|
|
peterr
Posts: 5971
|
Posted: 01/22/2004, 9:05 PM |
|
You can specify the number formatting in your server's Regional Options (in Windows Control Panel).
If this doesn't work, enter "0,00" in the "Format" property of your field in CCS.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
Kitto
|
Posted: 01/23/2004, 1:14 AM |
|
Quote peterr:
You can specify the number formatting in your server's Regional Options (in Windows Control Panel).
If this doesn't work, enter "0,00" in the "Format" property of your field in CCS.
I selected UK in my regional setting. Furthermore field is "float" in my MSSQL and there appear no comman in SQL.
I also tried "0,00" in the "Format" property but no helpful as it turned all values to 0.
I don't know from where comma is coming in my grid results. Please help.
Thanks.
|
|
|
DonB
|
Posted: 01/23/2004, 4:43 AM |
|
Excel will treat your data as text if it has one or more leading spaces.
Be sure you don't have ANY blank characters or that could be affecting you.
If by "grid" you were refering to the CCS Grid (and not the Excel grid),
then be sure the cells are setup with "Float" datatype in the grid
properties. It wasn't clear to me if you had also set up the grid data type
as a "float".
As an absolute last resort, you could specify the query with
CONVERT(varchar(4),<columnname>) and convert the float to a character type
and treat it all as text, but you shouldn't have to go to that extreme.
--
DonB
http://www.gotodon.com/ccbth
"Kitto" <Kitto@forum.codecharge> wrote in message
news:64010e5f7c29e7@news.codecharge.com...
> Quote peterr:
> You can specify the number formatting in your server's Regional Options
(in Windows Control Panel).
> If this doesn't work, enter "0,00" in the "Format" property of your field
in CCS.
>
> I selected UK in my regional setting. Furthermore field is "float" in my
MSSQL and there appear no comman in SQL.
>
> I also tried "0,00" in the "Format" property but no helpful as it turned
all values to 0.
>
> I don't know from where comma is coming in my grid results. Please help.
>
> Thanks.
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|