125 reputation
12
bio website ctp.com
location Switzerland
age 41
visits member for 3 years, 5 months
seen 9 hours ago

More than 15 years experience in IT consulting for the following business:

  • Telecomunications
  • Private banking
  • Finance / trading
  • Public sector
  • International organization (NGO's)
  • Retail
  • Food industry

1d
revised Proxy PAC Rules - myIpAddress() does not take the right IP
updated with potential solutions, but also not fully working
May
16
revised Proxy PAC Rules - myIpAddress() does not take the right IP
retag
May
15
comment What are the Windows A: and B: drives used for?
... and this was my first floppy... powered direcly by AC 220V: funny!
May
9
awarded  Excavator
May
9
revised How do I hide meeting attendees in Outlook 2010?
removed thanks, improved spelling
May
9
suggested suggested edit on How do I hide meeting attendees in Outlook 2010?
Mar
26
comment Excel How to make Text Qualifier editable or add a new entry in the existing list?
I read as well this post mentionning the sep=, in the first line of the CSV and I was thinking to get a similar code for the Text Qualifier but did not find anything on Internet.
Mar
26
comment Excel How to make Text Qualifier editable or add a new entry in the existing list?
In fact I made something very similar because the html attributes separator (name="value") can be single quote as well (my preferred way: name='value') then for me it is more a workaround than a Excel solution.
Mar
26
revised Excel How to make Text Qualifier editable or add a new entry in the existing list?
corrected with the right term
Mar
26
comment Excel How to make Text Qualifier editable or add a new entry in the existing list?
@Raystafarian I have no problem with delimiter (between columns) it is the text qualifier I cannot change (only the three values mentioned)
Mar
26
asked Excel How to make Text Qualifier editable or add a new entry in the existing list?
Mar
24
comment How to prevent Excel to use the OS regional settings for date patterns in formulas
But it does not answer my question. I want to be able to write dd/mm/yyyy in my Excel sheet even the OS wants "jj/mm/aaaa". I tried to change my OS locale and the output is changing, then Excel does not adapt according the user's Locale. If I write "jj.mm.aaaa" (as in French) and I change my locale to be US, the Excel shows: "jj.03.aaaa" which is not adapted.
Mar
18
asked How to prevent Excel to use the OS regional settings for date patterns in formulas
Mar
18
comment Excel TEXT function does not work properly
@barryhoudini then you can ask Microsoft why they create such function. My goal was to make some formatting programmatically (or in a cell through a built-in function). The case was made simple on purpose to be in a proper format for the SU site.
Mar
17
accepted Excel TEXT function does not work properly
Mar
17
comment Excel TEXT function does not work properly
and nothing state this in this official doc: goo.gl/byIktN
Mar
17
comment Excel TEXT function does not work properly
In the past I remember this language/localisation specific keyword are totally messy: I hade to use the function SOMME({range}) instead SUM({range} if the Excel was installed in French language. Again I though installing the software in English will make these *** ways disappear.
Mar
17
comment Excel TEXT function does not work properly
You got it... but for me it is jj.mm.aaaa as in the French part of Switzerland. I found this stupid because my OS and Office are in English. I was expecting to make all the language specific (macro and VBA code) to be in English. It means if I give you my Excel file you will not see the same things because you do not have the same "localisation". Is there no way to overrides this 'wrong' behaviour?
Mar
17
asked Excel TEXT function does not work properly
Mar
5
comment Why is windows constantly reading my harddisk?
The only time I needed a system restore it did not work and I had to re-install all windows and all softwares... Now I backup all my data (thanks to gdrive, dropbox and oneDrive) and rely only on virtual machines (backuped in external hdd)