Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 22nd 07, 07:51 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 4
Default Combobox changes the decimal commas to dots - How to prevent it?

Hi!

I have tried to use a combobox in selection between values which have a
decimal part. As I'm European I use commas as decimal separators. However
although in the selection list of combobox the decimal separator is comma,
the chosen value in the linked cell is written with a dot and so I cannot use
the value as as a source value for calculation. Why is this happening? Why
does the combobox change the decimal separator? The weirdest thing about this
is that sometimes the combobox has returned the right value with a comma as
decimal separator.

Can anyone help with this?

Thanks in advance,
Erkka

  #2   Report Post  
Old February 22nd 07, 11:40 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 9,101
Default Combobox changes the decimal commas to dots - How to prevent it?

Microsoft doesn't like the Europeans. Yesterday somebody was sending the
European date formatt to a combo box and kept on getting the US format. The
solution was to convert to a string before sending the date to the combobox.

"Erkka" wrote:

Hi!

I have tried to use a combobox in selection between values which have a
decimal part. As I'm European I use commas as decimal separators. However
although in the selection list of combobox the decimal separator is comma,
the chosen value in the linked cell is written with a dot and so I cannot use
the value as as a source value for calculation. Why is this happening? Why
does the combobox change the decimal separator? The weirdest thing about this
is that sometimes the combobox has returned the right value with a comma as
decimal separator.

Can anyone help with this?

Thanks in advance,
Erkka

  #3   Report Post  
Old February 23rd 07, 08:20 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 4
Default Combobox changes the decimal commas to dots - How to prevent i

Finally got it working, just needed to change the source values to text with
=TEXT(a1;"0,00")

Thanks Joel for the tip!

-Erkka

"Joel" kirjoitti:

Microsoft doesn't like the Europeans. Yesterday somebody was sending the
European date formatt to a combo box and kept on getting the US format. The
solution was to convert to a string before sending the date to the combobox.

"Erkka" wrote:

Hi!

I have tried to use a combobox in selection between values which have a
decimal part. As I'm European I use commas as decimal separators. However
although in the selection list of combobox the decimal separator is comma,
the chosen value in the linked cell is written with a dot and so I cannot use
the value as as a source value for calculation. Why is this happening? Why
does the combobox change the decimal separator? The weirdest thing about this
is that sometimes the combobox has returned the right value with a comma as
decimal separator.

Can anyone help with this?

Thanks in advance,
Erkka



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change dots to commas!! Andreas Excel Discussion (Misc queries) 1 November 18th 06 12:55 AM
connecting dots on a chart [email protected] Excel Discussion (Misc queries) 0 September 18th 06 07:09 PM
my printing comes out in dots instead of lines. Finance Lady Excel Discussion (Misc queries) 2 August 30th 06 03:57 AM
Change Dots into Commas as Decimal Divider xenia Excel Discussion (Misc queries) 2 August 8th 05 09:48 AM
dots instead of grid lines wrexx Excel Worksheet Functions 1 February 1st 05 11:52 PM


All times are GMT +1. The time now is 02:19 PM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017