SOLVED

Number Formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-1688824%22%20slang%3D%22en-US%22%3ENumber%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1688824%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Everyone%20and%20Helpers%2C%3C%2FP%3E%3CP%3EI%20have%20to%20Excel%20Formatting%20Problem.%3C%2FP%3E%3CP%3EI%20have%20the%20Excel%20file%20in%2025k%20Rows%20%5B%20i%20attached%20Example%20the%20picture%5D%20this%20Excel%20file%20have%20the%20A%20Style%20Numbers%20Formatting%20but%20i%20want%20to%20Change%20the%20B%20Style%20numbers%20Formatting%20All%20Rows%20%5B%20Simply%20Rows%20Convert%20to%20Colum%5D%20Only%20Numbers.%20How%20is%20Convert%20or%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1688824%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1688837%22%20slang%3D%22en-US%22%3ERe%3A%20Number%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1688837%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23FF0000%22%3EWow%2C%20I%20am%20a%20new%20in%20Excel%2C%20Thank%20you%20So%20Much%20Great%20Help.%26nbsp%3B%20Its%20Working%26nbsp%3B%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1688835%22%20slang%3D%22en-US%22%3ERe%3A%20Number%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1688835%22%20slang%3D%22en-US%22%3Eyes%20sir%2C%20you%20a%20Correct%20Sorry%20for%20misunderstanding%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1688833%22%20slang%3D%22en-US%22%3ERe%3A%20Number%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1688833%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F800566%22%20target%3D%22_blank%22%3E%40hpranga%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESo%2C%20that's%20not%20about%20numbers%20format%2C%20that's%20about%20how%20to%20transpose%20column%20to%20row%2C%20correct%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20so%20you%20may%20use%20TRANSPOSE()%20function%20or%20Power%20Query.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi Everyone and Helpers,

I have to Excel Formatting Problem.

I have the Excel file in 25k Rows [ i attached Example the picture] this Excel file have the A Style Numbers Formatting but i want to Change the B Style numbers Formatting All Rows [ Simply Rows Convert to Colum] Only Numbers. How is Convert or    

 

3 Replies
best response confirmed by hpranga (New Contributor)
Solution

@hpranga 

So, that's not about numbers format, that's about how to transpose column to row, correct?

 

If so you may use TRANSPOSE() function or Power Query.

yes sir, you a Correct Sorry for misunderstanding

@Sergei Baklan 

Wow, I am a new in Excel, Thank you So Much Great Help.  Its Working