0

Querying from Excel to a SQL Server database with fields of data type Decimal(26,11). In other words, 26 digits before the decimal, plus 11 digits after the decimal. For example:

12345678901234567890123456.12345678901

Excel truncates them to 15 significant digits even if the column is preformatted as Text. In this example:

12345678901234500000000000.00000000000

How can we make Excel stop truncating them to 15 significant digits?

BTW we do understand that we won't be able to do math on the numbers in Excel without losing precision. We just want to get them as text in Excel, querying fields from SQL Server with data type Decimal(26,11). Any suggestions?

Greg Lovern
  • 178

1 Answers1

0

It works fine for me to use 12345678901234567890123456.12345678901 since my system decimal separator is "," not ".". So a stupid fix is going to options and change that.
If possible, you could try adding ' in front of the number, to keep it from doing this.

Also duplicate: Why is Excel truncating my 16-digit numbers?

Community
  • 1
Christofer Weber
  • 1,363
  • 1
  • 8
  • 14