No announcements
Found 1752515 threads
-
0 VotesString formatting leading spaces
The number of spaces need to match the number of digits of the highest integer in the group.Answered | 5 Replies | 2608 Views | Created by Solitaire - Sunday, October 23, 2011 6:59 PM | Last reply by Cor Ligthert - Tuesday, October 25, 2011 8:02 AM
-
1 Votes
Field formatting [NUMBER] - no comma please
I need to be able to enter it in the form and not have the comma's show up.Answered | 3 Replies | 7756 Views | Created by MMMaolney - Wednesday, November 9, 2011 2:55 PM | Last reply by UNC Bob - Monday, April 6, 2015 1:49 PM -
7 Votes
Exporting numeric query result in the right format
Am I right to assume that this issue with copying numeric data into Excel with European locale hasn't been fixed?Answered | 10 Replies | 14467 Views | Created by pscorca - Wednesday, January 20, 2010 4:37 PM | Last reply by pituach - Friday, December 5, 2014 2:36 PM -
0 Votes
The proper format of float number
DECIMAL() and NUMERIC() are better choices.Answered | 10 Replies | 1135 Views | Created by chcw - Saturday, January 30, 2016 10:58 AM | Last reply by Erland Sommarskog - Monday, February 1, 2016 11:33 AM -
2 Votes
Display numbers without commas
Formula would be: =text([NumberColumn],"0") This will convert the number entered into the NumberColumn into a single line of text - removing ...Answered | 6 Replies | 54046 Views | Created by jordanmills - Thursday, August 21, 2008 6:02 PM | Last reply by SushiFest - Thursday, January 30, 2014 4:28 PM -
0 Votes
numeric format with commas, proper number of leading spaces for right alignment
I have solved my problem by drilling down into the intellisense and figuring out how to right align the numbers.Answered | 10 Replies | 387 Views | Created by Anonymous - Saturday, July 4, 2020 4:39 AM | Last reply by Anonymous - Tuesday, July 7, 2020 10:22 PM -
1 Votes
Comma displaying in calculated number
This actually sounds like the better option as the field would remain a number and sortable.Answered | 6 Replies | 14114 Views | Created by richardlpalmer - Friday, May 22, 2009 10:11 PM | Last reply by Garou787 - Wednesday, February 19, 2014 12:55 AM -
1 Votes
leading zero to numbers in csv in ssis
Or google how to retain leading zeros in excel and you might get some workaround but basically AFAIK every workaround would be to somehow make ...Answered | 5 Replies | 16228 Views | Created by S Prashant - Friday, October 21, 2011 4:43 PM | Last reply by BIRocks - Sunday, December 4, 2011 4:27 PM -
5 Votes
Right align 123.2342 and 12343.3456
@Naom and Adam Haines: I use SSMS, how can I set monospace fonts (I don't want to pad with other chars than space itself...) ?Answered | 7 Replies | 3707 Views | Created by OlegKomarov - Wednesday, March 24, 2010 12:06 PM | Last reply by Naomi N - Wednesday, March 24, 2010 1:41 PM -
0 Votes
Format number with comma and 1 decimal point
" in the right places, then please show the code that currently formats the number.Answered | 8 Replies | 17336 Views | Created by dbdrtso1 - Thursday, December 26, 2013 9:49 PM | Last reply by --CELKO-- - Friday, December 27, 2013 3:07 PM -
2 Votes
Left Align and Right Align in Same "TextBox"?
Text alignment applies to a control so you cannot apply left and right alignment to the same control.Answered | 3 Replies | 6071 Views | Created by RobTencents - Tuesday, May 19, 2015 4:21 PM | Last reply by --Dennis-- - Friday, March 23, 2018 7:26 PM -
3 Votes
right align in label text
Or you can align stirng with spaces, by using Sring.Format method, and inside braces define alignnment. 1st number is the index element, 2nd number is meant for ...Answered | 3 Replies | 15998 Views | Created by Raymond Chiu - Thursday, October 6, 2011 10:13 AM | Last reply by Mitja Bonca - Thursday, October 6, 2011 10:56 AM -
2 Votes
Add leading spaces
DECLARE @FixLength INT = 15 SELECT CASE WHEN LEN(EmpName)Answered | 4 Replies | 4158 Views | Created by mm6991 - Wednesday, December 28, 2011 1:37 AM | Last reply by PA-Singh - Thursday, December 29, 2011 6:36 PM -
0 Votes
Mapping Data Flow - CSV File with Comma in Numeric Values
Have you tried specifying format in projection tab of the source.Answered | 5 Replies | 525 Views | Created by Pedro Fiadeiro - Thursday, April 2, 2020 10:41 PM | Last reply by Pedro Fiadeiro - Monday, April 13, 2020 8:42 PM -
0 Votes
Format Textbox using Standard Numeric Format String "N"
The custom format identifier for including thousands separators is ",".Answered | 2 Replies | 1555 Views | Created by David.Warwick - Thursday, August 16, 2012 3:43 AM | Last reply by David.Warwick - Thursday, August 16, 2012 11:56 AM -
3 Votes
Issue with number column with comma while publishing spreadsheet list to SharePoint list
Just change your existing column properties will remove your comma in number.Answered | 5 Replies | 43376 Views | Created by winnerMedas - Tuesday, December 9, 2008 10:04 PM | Last reply by Praveen Kodali - Thursday, November 11, 2010 5:57 AM -
0 Votes
formatting numbers in VB.Net
Supported by: All numeric types.Answered | 10 Replies | 4212 Views | Created by V. Shane Curtis - Wednesday, March 7, 2012 8:04 PM | Last reply by V. Shane Curtis - Thursday, March 8, 2012 12:06 AM -
0 Votes
format number add commas every time
Hi When I use formatNumber, depending on my users culture on their computer the number gets formatted like "123 456 ...Answered | 4 Replies | 2128 Views | Created by code-in-time - Tuesday, June 26, 2012 5:31 PM | Last reply by Armin Zingler - Tuesday, June 26, 2012 6:38 PM -
3 Votes
Calculate numbers with comma and decimal
One of the overloads allows commas and decimal points.Answered | 4 Replies | 780 Views | Created by nadzson - Thursday, November 6, 2014 12:40 PM | Last reply by nadzson - Thursday, November 6, 2014 1:09 PM -
4 Votes
format specifiers+alignment
*text to align to the right sorry :-SAnswered | 4 Replies | 8114 Views | Created by yourDudeness - Tuesday, September 28, 2010 3:48 AM | Last reply by Ed Price - MSFT - Tuesday, October 30, 2012 9:48 PM - Items 1 to 20 of 1752515 Next ›
No announcements
