+ Reply to Thread
Results 1 to 5 of 5

Help Formatting Numbers in Formulas

Hybrid View

  1. #1
    Forum Expert
    Join Date
    12-09-2014
    Location
    Trakai, Lithuania
    MS-Off Ver
    2016
    Posts
    1,412

    Re: Help Formatting Numbers in Formulas

    Power Query
    let
        Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
        #"Split Column by Delimiter" = Table.SplitColumn(Source,"Column1",Splitter.SplitTextByDelimiter("_", QuoteStyle.Csv),{"Column1.1", "Column1.2", "Column1.3"}),
        #"Removed Columns" = Table.RemoveColumns(#"Split Column by Delimiter",{"Column1.1"}),
        #"Changed Type" = Table.TransformColumnTypes(#"Removed Columns",{{"Column1.2", type date}, {"Column1.3", Int64.Type}})
    in
        #"Changed Type"
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 02-14-2019, 01:27 PM
  2. [SOLVED] Formatting numbers and formulas as text doesn't really work
    By chengafni in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 10-02-2017, 06:33 AM
  3. Formatting and formulas for dates, fills & numbers
    By LG99 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-05-2013, 10:58 PM
  4. [SOLVED] Conditional formatting - formatting the lowest 2 numbers in a list of 12 numbers
    By ktbb0312 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-09-2013, 09:59 AM
  5. Replies: 2
    Last Post: 05-15-2013, 11:08 PM
  6. [SOLVED] Conditional Formatting Formulas for Date, Text and Values/Numbers
    By pblobe in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-09-2013, 12:26 AM
  7. Formatting of numbers affecting formulas
    By JakeMann in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-03-2013, 03:56 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1