Formatting numbers in PowerShell to remove the "," for numbers > 1k?

Question

I read the page about formatting PS Formatting, but my needs are a little different.

If I use numeric formatting for numbers bigger than 1000 I will always get something like this:

$x = 1000
"{0:N2}" -f $x
 = 1,000.00

But what I need is: 1000.00 since I can't work with commas here.

So how do I make this work?

score 4 · Accepted Answer · answered Dec 06 '13 at 14:44

4

Don't use the N format specifier. Use F (fixed-point) instead:

C:\PS> "{0:F2}" -f 1000
1000.00

See this MSDN topic on all the standard .NET number format specifiers.

answered Dec 06 '13 at 14:44

Keith Hill

The funny part is that it depends on system language. So for US it's for example 1000.86 and germany its 1000,86 using the same formatting. is there a formatting which switches to US? – RayofCommand Dec 09 '13 at 13:00
ahh found your other answer regarding this :) http://stackoverflow.com/questions/2379514/powershell-formatting-values-in-another-culture – RayofCommand Dec 09 '13 at 13:56

score 1 · Answer 2 · answered Dec 06 '13 at 14:43

1

This should do what you need.

'{0:f2}' -f 1000

answered Dec 06 '13 at 14:43

Rynant

2 Answers2