dot instead of comma

RaymondR32 · Mar 22nd, 2002, 04:03 AM

Hi all,

I have some figures and want to change the comma´s into dots. When I apply the replace function the numbers are really weird. So for example 456,90 must be changed to 456.90 . Somebody know the answer ?

Regards, Raymond

Derek · Mar 22nd, 2002, 04:10 AM

Hi
Go to format cells, number, and untick the box "use 1000 separator"
If you want 45690 to become 456.90 you need to divide it by 100.
regards
Derek

RaymondR32 · Mar 22nd, 2002, 04:12 AM

Hi Derek,

I did not use the 1000 seperator. Still not working....

Raymond

Derek · Mar 22nd, 2002, 04:20 AM

Hi
Click into the cell and go to format cell and tell me what formatting is being used.
Derek

RaymondR32 · Mar 22nd, 2002, 04:24 AM

hi derek,

it is number with 2 decimals

raymond

Derek · Mar 22nd, 2002, 04:58 AM

Hi Raymond
This is a bit wierd. Are you using a comma as the decimal seperator? Go to Settings,Control Panel,Regional Settings,Number and see what is in the box against "Decimal Symbol".
If it is a comma, change it to a dot
If it is already a dot, I'm afraid I don't know the answer.
regards
Derek

flightjock · Mar 22nd, 2002, 05:03 AM

I think you have to change your Windows regional settings. Click Start, then Settings, then Control Panel, then Regional settings, select the Number Tab and change the decimal symbol to period i.s.o comma.

flightjock · Mar 22nd, 2002, 05:05 AM

Sorry, Derek answered just a few seconds before me. Fortunately with the same answer.

RaymondR32 · Mar 22nd, 2002, 05:37 AM

Hi guys,

Thanks for your help. It worked. You made me very happy today... Have a nice weekend all.

Regards,

Raymond

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 22nd, 2002, 04:03 AM	#1
RaymondR32 New Member Join Date: Feb 2002 Posts: 12	Hi all, I have some figures and want to change the comma´s into dots. When I apply the replace function the numbers are really weird. So for example 456,90 must be changed to 456.90 . Somebody know the answer ? Regards, Raymond

Mar 22nd, 2002, 04:10 AM	#2
Derek Board Regular Join Date: Feb 2002 Location: Perth Australia Posts: 1,567	Hi Go to format cells, number, and untick the box "use 1000 separator" If you want 45690 to become 456.90 you need to divide it by 100. regards Derek

Mar 22nd, 2002, 04:12 AM	#3
RaymondR32 New Member Join Date: Feb 2002 Posts: 12	Hi Derek, I did not use the 1000 seperator. Still not working.... Raymond

Mar 22nd, 2002, 04:20 AM	#4
Derek Board Regular Join Date: Feb 2002 Location: Perth Australia Posts: 1,567	Hi Click into the cell and go to format cell and tell me what formatting is being used. Derek

Mar 22nd, 2002, 04:24 AM	#5
RaymondR32 New Member Join Date: Feb 2002 Posts: 12	hi derek, it is number with 2 decimals raymond

Mar 22nd, 2002, 04:58 AM	#6
Derek Board Regular Join Date: Feb 2002 Location: Perth Australia Posts: 1,567	Hi Raymond This is a bit wierd. Are you using a comma as the decimal seperator? Go to Settings,Control Panel,Regional Settings,Number and see what is in the box against "Decimal Symbol". If it is a comma, change it to a dot If it is already a dot, I'm afraid I don't know the answer. regards Derek

Mar 22nd, 2002, 05:03 AM	#7
flightjock New Member Join Date: Mar 2002 Location: Schiphol Airport, Netherlands Posts: 48	I think you have to change your Windows regional settings. Click Start, then Settings, then Control Panel, then Regional settings, select the Number Tab and change the decimal symbol to period i.s.o comma.

Mar 22nd, 2002, 05:05 AM	#8
flightjock New Member Join Date: Mar 2002 Location: Schiphol Airport, Netherlands Posts: 48	Sorry, Derek answered just a few seconds before me. Fortunately with the same answer.

Mar 22nd, 2002, 05:37 AM	#9
RaymondR32 New Member Join Date: Feb 2002 Posts: 12	Hi guys, Thanks for your help. It worked. You made me very happy today... Have a nice weekend all. Regards, Raymond