Access: When exporting the ACCESS File as CSV format it limit the decimal values to 2 points

Scenario:
I had an access file and I have declared the data types of the column to Numeric, Field Size: Double, Format:Percentage, Decimal places:Auto. Even after this, when I was exporting the access query to flat file format (CSV) it was showing only 2 decimal places.

Solution:

  1. Save teh data types of the column to Numeric, Field Size: Double, format: General number, Decimal places: 10, and then Save the access query as excel file format (.xlsx)
  2. Save the data types of the column to Numeric, Field Size: Double, format: Percentage, Decimal places: 10 and
    a4

    1. Go to Control panel–>Region and Language
    2. Click button Additional settings
    3. On the number tab–>No. of digits after decimal: 9

Problem scenario pictures:

a1

s2

Advertisements

Excel: Extract Only Numbers From Text String

Extract Only Numbers From Text String

  1. You will need to insert this formula as an array.
  2. Select a cell in Excel, paste the formula and then press CTRL + SHIFT + ENTER. OR Excel formula surrounds the formula with braces { }.Formula: =MID(A1,MATCH(TRUE,ISNUMBER(1*MID(A1,ROW($1:$101),1)),0),COUNT(1*MID(A1,ROW($1:$101),1)))Formula with braces : {=MID(A1,MATCH(TRUE,ISNUMBER(1*MID(A1,ROW($1:$101),1)),0),COUNT(1*MID(A1,ROW($1:$101),1))) }