|
|
How to convert Decimal number with comma(,) as decimal separator to dot(.)
Hi,
I am having problem with decimals in VBA code.
I am "injecting" value from textbox into UPDATE sql statment, but I get an
error because i am having comma as a separator.
How to convert 0,254 into 0.255 without changing regional settings!
|
|
0
|
|
|
|
Reply
|
 Domac
|
5/10/2006 11:26:40 AM |
|
Use the replace function:
Replace("String",",",".")
--
hth,
SusanV
"Domac" <domac.kovacevic@zg.t-com.hr> wrote in message
news:%238PfdSCdGHA.4900@TK2MSFTNGP02.phx.gbl...
> Hi,
>
> I am having problem with decimals in VBA code.
> I am "injecting" value from textbox into UPDATE sql statment, but I get an
> error because i am having comma as a separator.
> How to convert 0,254 into 0.255 without changing regional settings!
>
|
|
|
0
|
|
|
|
Reply
|
SusanV
|
5/10/2006 12:04:37 PM
|
|
|
1 Replies
1830 Views
(page loaded in 0.452 seconds)
Similiar Articles: How to convert Decimal number with comma(,) as decimal separator ...How to convert Decimal number with comma(,) as decimal separator ... Number Format. Switch Comma to Dot - microsoft.public.excel ..... third dialog page and change ... Number Format. Switch Comma to Dot - microsoft.public.excel ...How to convert Decimal number with comma(,) as decimal separator ... Number Format. Switch Comma to Dot - microsoft.public.excel ..... third dialog page and change ... Comma as a decimal symbol - microsoft.public.accessComma as a decimal symbol (Regional and Language settings ... How to convert Decimal number with comma(,) as decimal separator ... Switch Comma to Dot - microsoft.public ... Comma as a decimal symbol (Regional and Language settings ...How to convert Decimal number with comma(,) as decimal separator ... Switch Comma to Dot - microsoft.public.excel ... have (comma for decimal ... decimal symbol (Regional ... i want to convert decimals into time format - microsoft.public ...... with double minus> =--TimeFrom(.) 'Examples (dot separator ... How to convert Decimal number with comma(,) as decimal separator ... i want to convert decimals into time ... Convert Currency to String but keep commas - microsoft.public ...Str(dblNum) The STR() function converts the number to a string with ... How to convert Decimal number with comma(,) as decimal separator ... Switch Comma to Dot ... change csv list separator in excel 2007 Dutch version - microsoft ...How to convert Decimal number with comma(,) as decimal separator ... change csv list separator in excel 2007 Dutch version - microsoft ... I already tried to change the ... Decimal point vs comma - microsoft.public.mac.office.excel ...How to convert Decimal number with comma ... of the latest: ... adds a character ... the free encyclopedia In Dominican Republic the decimal separator is a point, not a comma. how to convert time to decimal format - microsoft.public.excel ...How to convert Decimal number with comma(,) as decimal separator ... How to convert Decimal number with comma(,) as decimal separator ... Number ... i want to convert ... Decimal places in OLAP Cube Data - microsoft.public.project.server ...You will see that your numbers are now properly formatted, supressing the decimals and adding comma as the thousands separator. Hope this helps. How to convert Decimal number with comma(,) as decimal separator ...How to convert Decimal number with comma(,) as decimal separator ... Number Format. Switch Comma to Dot - microsoft.public.excel ..... third dialog page and change ... How to convert Decimal number with comma(,) as decimal separator ...How to convert Decimal number with comma(,) as decimal separator to dot(.) Domac Guest How to convert Decimal number with comma(,) as decimal separator ...How to convert Decimal number with comma(,) as decimal separator to dot(.) ... I am having problem with decimals in VBA code. I am ... Excel 2007 prob - my soft recognize decimal point as comma instead ...... prob - my soft recognize decimal point as comma instead of dot? ... it will recognize it as a number. I've tried to change ... graph, it still shows the number in comma ... How can I change the decimal separator from a dot to a comma?10 Minutes Web ... Document ID: 767: Subject: How can I change the decimal separator from a dot to a comma? 7/22/2012 4:09:51 PM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
5 followers. 