How to take numbers Left aligned or center aligned

Question

0.00/5 (No votes)

See more:

Hello Sir,
I m Converting data in sqlserver to excel file when the report is generating all numbers are coming right aligned so that it is taking lots of space I want it to be center or left aligned so that when I print page it shouldn't go beyond that page

my table in sqlserver2005

Sr.No. Date EndTime StartTime Project Module Form WorkType Status Remarks
1 12/12/2011 09:30 10:30 ABBank PIS MasterForm Coding 50% ok

all numbers are coming right aligned how to set it left or center I m doing by use of gridview all data comes in dt then that dt convert to excel

Please Guide me

Posted 15-Dec-11 20:10pm

Prashant Srivastava LKO

Add a Solution

Comments

thatraja 16-Dec-11 3:08am

In report? which one? SSRS? Crystal?

Prashant Srivastava LKO 16-Dec-11 3:53am

It is in excel sir

Prashant Srivastava LKO 16-Dec-11 3:55am

Direct conversion of Grid to excel

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2011-12-15T21:12:00

This has nothing to do with SQL - it is just returning a numeric value which is being formatted for presentation by whatever display software you are using. Look at how the display element works - you say it is converted to Excel, which automatically right formats numeric values for presentation, so you need to look at how that section of your code is working. Since we don't know how you are displaying the data, we can't give you a specific solution.