I used dot to represent this character: .

I was asking Bob if he meant that the custom format should be:
#,##0
or
#,##0.

Was Bob using that dot character to indicate the end of sentence--or did he mean
for it to be part of the custom format?

Roee wrote:

I'm not sure what you mean. I use a dot as a decimal point (and not comma as
in France for example).
What is the difference between a dot and a period in that context?

"Dave Peterson" wrote:

Is that dot a decimal point or a period (end of sentence)?

<vbg

Bob Phillips wrote:

Use a format of #,##0.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Roee" wrote in message
...
Hello,

I would like to use the 1000 sperator but I don't want to specify fixed
decimal places.
For example, if the cell contains the number 300, I want it to show 300
and
not 300.00, but I still wan't to use the 1000 sperator.
How do I do that?

The "General" formatting showes the decimal places like I want (only if
exists) but does not allow 1000 sperator and the "Number" formatting
requires
defining a fixed number of decimal places.

Thanks,
Roee.

--

Dave Peterson


--

Dave Peterson