Removing Thousands separator

Imported from Yahoo
1

Hi all,
I edit the Comet website and get Sailwave files passed onto me by our Results Sec. However these files include numbers in the thousands and are displayed with a comma to separate the thousands off. To save space I, once imported into Excel, have to edit all of the effected cells and reformat the number to ‘No thousands separator’ which can be a pain.

Is it possible to display numbers with No thousands separator to start off with?

Thanks
Nigel

2

Hi Nigel,

  I am sorry I do not understand what you are saying is it possible

to show examples please?

Which numbers appearing with a comma in numbers greater than 999.

Kind regards,

Huw

···

On 29/10/2017 16:52,
[sailwave] wrote:

n.fern@ntlworld.com

Hi all,
I edit the Comet website and get Sailwave files passed
onto me by our Results Sec. However these files include
numbers in the thousands and are displayed with a comma to
separate the thousands off. To save space I, once imported
into Excel, have to edit all of the effected cells and
reformat the number to ‘No thousands separator’ which can
be a pain.

          Is it possible to display numbers with No thousands

separator to start off with?

          Thanks
          Nigel


Virus-free. www.avast.com

3

Hi,

For example 10,000 which I then edit to 10000 in Excel but if I can get the Results Sec to set up Sailwave so as not to use a comma to start off with then it’s a win, win situation.

Nigel

···

From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com]
Sent: Sunday, October 29, 2017 5:01 PM
To: sailwave@yahoogroups.com
Subject: Re: [sailwave] Removing Thousands separator

Hi Nigel,

I am sorry I do not understand what you are saying is it possible to show examples please?

Which numbers appearing with a comma in numbers greater than 999.

Kind regards,

Huw

On 29/10/2017 16:52, n.fern@ntlworld.com [sailwave] wrote:

Hi all,
I edit the Comet website and get Sailwave files passed onto me by our Results Sec. However these files include numbers in the thousands and are displayed with a comma to separate the thousands off. To save space I, once imported into Excel, have to edit all of the effected cells and reformat the number to ‘No thousands separator’ which can be a pain.

Is it possible to display numbers with No thousands separator to start off with?

Thanks
Nigel

Image removed by sender.

Virus-free. www.avast.com

4

Hi Nigel,

  I understand what a comma separator in 1000's is. What I was

looking for you to supply is an example output from Sailwave that
has a comma separator in numbers greater than 999.

Also a copy of the Sailwave file would be useful.

Kind regards,

Huw

···

On 29/10/2017 18:51, ‘Nigel Fern’
[sailwave] wrote:

n.fern@ntlworld.com

Hi,

              For example

10,000 which I then edit to 10000 in Excel but if I
can get the Results Sec to set up Sailwave so as not
to use a comma to start off with then it’s a win, win
situation.

Nigel

From:

                  [] Sunday, October 29, 2017 5:01 PM

Re: [sailwave] Removing Thousands
separator

Hi Nigel,

                  I am sorry I do not understand what you are

saying is it possible to show examples please?

                  Which numbers appearing with a comma in numbers

greater than 999.

Kind regards,

Huw

On 29/10/2017 16:52, n.fern@ntlworld.com
[sailwave] wrote:

Hi all,
I edit the Comet website and get Sailwave
files passed onto me by our Results Sec.
However these files include numbers in the
thousands and are displayed with a comma to
separate the thousands off. To save space I,
once imported into Excel, have to edit all of
the effected cells and reformat the number to
‘No thousands separator’ which can be a pain.

                      Is it possible to display numbers with No

thousands separator to start off with?

                      Thanks
                      Nigel


                              Virus-free.

www.avast.com

sailwave@yahoogroups.commailto:sailwave@yahoogroups.com
Sent:
**To:**sailwave@yahoogroups.com
Subject:

5

Ooops, sorry.

Please see ‘Total’ and ‘Nett’ columns. If a competitor misses an event they are scored 1,000 points.

Hope this helps

Nigel

···

From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com]
Sent: Sunday, October 29, 2017 7:17 PM
To: sailwave@yahoogroups.com
Subject: Re: [sailwave] Removing Thousands separator

Hi Nigel,

I understand what a comma separator in 1000’s is. What I was looking for you to supply is an example output from Sailwave that has a comma separator in numbers greater than 999.

Also a copy of the Sailwave file would be useful.

Kind regards,

Huw

On 29/10/2017 18:51, ‘Nigel Fern’ n.fern@ntlworld.com [sailwave] wrote:

Hi,

For example 10,000 which I then edit to 10000 in Excel but if I can get the Results Sec to set up Sailwave so as not to use a comma to start off with then it’s a win, win situation.

Nigel

From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com]
Sent: Sunday, October 29, 2017 5:01 PM
To: sailwave@yahoogroups.com
Subject: Re: [sailwave] Removing Thousands separator

Hi Nigel,

I am sorry I do not understand what you are saying is it possible to show examples please?

Which numbers appearing with a comma in numbers greater than 999.

Kind regards,

Huw

On 29/10/2017 16:52, n.fern@ntlworld.com [sailwave] wrote:

Hi all,
I edit the Comet website and get Sailwave files passed onto me by our Results Sec. However these files include numbers in the thousands and are displayed with a comma to separate the thousands off. To save space I, once imported into Excel, have to edit all of the effected cells and reformat the number to ‘No thousands separator’ which can be a pain.

Is it possible to display numbers with No thousands separator to start off with?

Thanks
Nigel

Image removed by sender.

Virus-free. www.avast.com

6

Hi Nigel,

  Thank you for  the extra detail it is helpful. I now understand

your situation.

  I have never seen this as I have never had a circumstance where

Total and/or Net points exceed 999.

  I have just run a quick test and confirm what you are seeing.

Currently I am not aware of any setting in Sailwave that can
switch a 1000’s comma separator on or off.

  It is something possibly for the enhancement list but a rare

requirement I would suggest.

Kind regards,

Huw

···

On 29/10/2017 19:50, Huw Pearce wrote:

Hi Nigel,

    Thank you for  the extra detail it is helpful. I now understand

your situation.

    I have never seen this as I have never had a circumstance where

Total and/or Net points exceed 999.

    I have just run a quick test and confirm what you are seeing.

Currently I am not aware of any setting in Sailwave that can
switch a 1000’s comma separator on or off.

    It is something possibly for the enhancement list but a rare

requirement I would suggest.

Kind regards,

Huw

    On 29/10/2017 19:30, 'Nigel Fern' [sailwave] wrote:

n.fern@ntlworld.com

                Ooops,

sorry.

                Please see

‘Total’ and ‘Nett’ columns. If a competitor misses
an event they are scored 1,000 points.

                Hope this

helps

Nigel

From:
[]
Sunday, October 29, 2017 7:17 PM
Re: [sailwave] Removing
Thousands separator

Hi Nigel,

                    I understand what a comma separator in 1000's

is. What I was looking for you to supply is an
example output from Sailwave that has a comma
separator in numbers greater than 999.

                    Also a copy of the Sailwave file would be

useful.

Kind regards,

Huw

                      On 29/10/2017 18:51, 'Nigel

Fern’ n.fern@ntlworld.com
[sailwave] wrote:

Hi,

                            For

example 10,000 which I then edit to
10000 in Excel but if I can get the
Results Sec to set up Sailwave so as not
to use a comma to start off with then
it’s a win, win situation.

Nigel

From: sailwave@yahoogroups.com
[mailto:sailwave@yahoogroups.com ]
Sent: Sunday, October 29,
2017 5:01 PM
To: sailwave@yahoogroups.com
Subject: Re: [sailwave]
Removing Thousands separator

Hi Nigel,

                                I am sorry I do not understand what

you are saying is it possible to
show examples please?

                                Which numbers appearing with a

comma in numbers greater than 999.

Kind regards,

Huw

                                  On 29/10/2017

16:52, n.fern@ntlworld.com
[sailwave] wrote:

Hi all,
I edit the Comet website and get
Sailwave files passed onto me by
our Results Sec. However these
files include numbers in the
thousands and are displayed with
a comma to separate the
thousands off. To save space I,
once imported into Excel, have
to edit all of the effected
cells and reformat the number to
‘No thousands separator’ which
can be a pain.

                                    Is it possible to display

numbers with No thousands
separator to start off with?

                                    Thanks
                                    Nigel


                                            Virus-free.

www.avast.com

sailwave@yahoogroups.commailto:sailwave@yahoogroups.com
Sent:
**To:**sailwave@yahoogroups.com
Subject:

7

Hi Nigel,

If you really want to remove the “,” from the thousands you should be able to create a publishing effect which would do that.

Jon

···

On 29 October 2017 at 20:30, ‘Nigel Fern’ n.fern@ntlworld.com [sailwave] sailwave@yahoogroups.com wrote:

Ooops, sorry.

Please see ‘Total’ and ‘Nett’ columns. If a competitor misses an event they are scored 1,000 points.

Hope this helps

Nigel

From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com]
Sent: Sunday, October 29, 2017 7:17 PM
To: sailwave@yahoogroups.com
Subject: Re: [sailwave] Removing Thousands separator

Hi Nigel,

I understand what a comma separator in 1000’s is. What I was looking for you to supply is an example output from Sailwave that has a comma separator in numbers greater than 999.

Also a copy of the Sailwave file would be useful.

Kind regards,

Huw

On 29/10/2017 18:51, ‘Nigel Fern’ n.fern@ntlworld.com [sailwave] wrote:

Hi,

For example 10,000 which I then edit to 10000 in Excel but if I can get the Results Sec to set up Sailwave so as not to use a comma to start off with then it’s a win, win situation.

Nigel

From: sailwave@yahoogroups.com [mailto:sailwave@yahoogroups.com]
Sent: Sunday, October 29, 2017 5:01 PM
To: sailwave@yahoogroups.com
Subject: Re: [sailwave] Removing Thousands separator

Hi Nigel,

I am sorry I do not understand what you are saying is it possible to show examples please?

Which numbers appearing with a comma in numbers greater than 999.

Kind regards,

Huw

On 29/10/2017 16:52, n.fern@ntlworld.com [sailwave] wrote:

Hi all,
I edit the Comet website and get Sailwave files passed onto me by our Results Sec. However these files include numbers in the thousands and are displayed with a comma to separate the thousands off. To save space I, once imported into Excel, have to edit all of the effected cells and reformat the number to ‘No thousands separator’ which can be a pain.

Is it possible to display numbers with No thousands separator to start off with?

Thanks
Nigel

Virus-free. www.avast.com

Jon Eskdale
07530 112233

Skype “eskdale”