When performing a query in Query Analyzer, I see the results for a column defined as "real" display as 1. What is this telling me and how can I see the real value? All forum topics Previous Topic Next Topic.
Honored Contributor. Scott: It is Excel's way of showing scientific notation. If a format contains a zero 0 or number sign to the right of an exponent code, Excel displays the number in scientific format and inserts an "E" or "e". The number of zeros or number signs to the right of a code determines the number of digits in the exponent.
I can set it to Scientific or change it from Scientific to Number to see the actual value. HTH Make a great day! Roger P. Thanks, Roger.
That helps a lot! You may receive emails, depending on your notification preferences. Show older comments. Kirti on 7 Dec Vote 1. Commented: madhan ravi on 14 Oct Accepted Answer: Walter Roberson. Thanks in advance. Stephen on 31 May Cancel Copy to Clipboard.
Accepted Answer. Walter Roberson on 7 Dec Vote 5. You may wish to give the command. Swati Sahai on 9 Jun Thank you. More Answers 3. Lalit Patil on 7 Dec Vote 0. Try in command window.. And no need to worry about this result.. Thanks Lalit!! Thanks a lot. Likewise for addition. Edwin Macharia on 17 Jul
0コメント