Submitted by David_H on 2015/01/20 01:48
Any way to get a number column to use a number separator "," for numbers of 1000 and above?
 
Thanks

Comments

Hi David,
I'm not using that kind of separator, but check the manual 4.075 Field Options section. You can use the format syntax specified there : http://www.apostate.com/vb-format-syntax 
So something like <format>###,##0.00</format> (I added the decimals at the end, but do as you see fit).would work; write that in the option section of the field properties of your field. 
 
-------------------------------------------------------
Windows 8.1
Sony Vaio S Series 13 (SVS131E21L)
Ram:8gb, CPU: Intel i5-3230M, 2.6ghz

David_H

2015/02/17 01:36

Permalink

[quote=Armando]
Hi David,
I'm not using that kind of separator, but check the manual 4.075 Field Options section. You can use the format syntax specified there : http://www.apostate.com/vb-format-syntax&nbsp;
So something like <format>###,##0.00</format> (I added the decimals at the end, but do as you see fit).would work; write that in the option section of the field properties of your field. [/quote]
 
Thanks.  This does work but strangely enough even without the .00 entered the two decimal places still show up (and I'd prefer they didn't).  Any suggestions?  Pierre?
 
 

Pierre_Admin

2015/02/17 14:04

Permalink

Numeric fields now have a UI to select the number format. I've updated page -- link to nonexistent node ID 404 -- to reflect this.
 
Basically: 
  • <format> is no longer required for numeric fields
  • Number fields now have a setting in the "Type" section to select the number format.
  • Standard, Currency and user-defined (using the syntax given below) is possible.
 

Armando

2015/02/28 12:17

Permalink

-------------------------------------------------------
Windows 8.1
Sony Vaio S Series 13 (SVS131E21L)
Ram:8gb, CPU: Intel i5-3230M, 2.6ghz

 Using the control panel regional settings does not do the trick ?
 

David_H

2015/01/20 16:23

Permalink

[quote=Pierre_Admin]Using the control panel regional settings does not do the trick ?[/quote]
I don't know what that means :).  I went to Tools>Field Properties and and looked at the various options for the field.  I don't see anything there about regional properties.  I do not know what "control panel" refers to.  Thanks Pierre.

Armando

2015/01/20 16:36

Permalink

[quote=David_H]
[quote=Pierre_Admin]Using the control panel regional settings does not do the trick ?[/quote]
I don't know what that means :).  I went to Tools>Field Properties and and looked at the various options for the field.  I don't see anything there about regional properties.  I do not know what "control panel" refers to.  Thanks Pierre.
[/quote]
 
Pierre is referring to Windows' Control  Panel; not IQ's.
-------------------------------------------------------
Windows 8.1
Sony Vaio S Series 13 (SVS131E21L)
Ram:8gb, CPU: Intel i5-3230M, 2.6ghz

David_H

2015/01/20 17:37

Permalink

Ah, my brain wasn't even thinking of Windows, in that case the windows control panel settings make no difference at all.

Armando

2015/01/20 18:07

Permalink

[quote=David_H]
Ah, my brain wasn't even thinking of Windows, in that case the windows control panel settings make no difference at all.
[/quote]
 
Then try my solution. Just paste the snippet in the option section of your field (field properties dialog)
.
-------------------------------------------------------
Windows 8.1
Sony Vaio S Series 13 (SVS131E21L)
Ram:8gb, CPU: Intel i5-3230M, 2.6ghz

You can add <format>standard</format> in the options section of the field properties
 
In the next release, I'll add a formatting option for the numeric fields