excel formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1607270%22%20slang%3D%22en-US%22%3Eexcel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1607270%22%20slang%3D%22en-US%22%3E%3CP%3Ehow%20to%20convert%20num%20to%20text%20in%20microsoft%20excel%20365%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1607368%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1607368%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F768644%22%20target%3D%22_blank%22%3E%40Sanjeev7166%3C%2FA%3E%26nbsp%3BThat%20could%20be%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DTEXT(%3CREF%3E%2C%220%22)%3C%2FREF%3E%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3Ewhere%20%3CREF%3E%20is%20the%20cell%20reference%20of%20the%20number%20you%20want%20to%20convert.%20Between%20the%20%22%22%2C%20you%20can%20indicate%20how%20you%20want%20the%20converted%20number%20need%20to%20be%20displayed.%20In%20this%20example%2C%20it%20will%20be%20displayed%20without%20decimals.%26nbsp%3B%3C%2FREF%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1607378%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1607378%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20Riny%2C%3C%2FP%3E%3CP%3EI%20TRIED%20BUT%20IT%20DINT%20WORK.%20IS%20THERE%20ANY%20OTHER%20WAY.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1607383%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1607383%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F768644%22%20target%3D%22_blank%22%3E%40Sanjeev7166%3C%2FA%3E%26nbsp%3BI%20wonder%20why%20%22it%20din't%20work%22.%20What%20are%20you%20trying%20to%20do%3F%20Can%20you%20give%20an%20example%20or%20upload%20a%20file%2C%20indicating%20what%20you%20are%20trying%20to%20achieve%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

how to convert num to text in microsoft excel 365

3 Replies

@Sanjeev7166 That could be

=TEXT(<ref>,"0")

where <ref> is the cell reference of the number you want to convert. Between the "", you can indicate how you want the converted number need to be displayed. In this example, it will be displayed without decimals. 

Dear Riny,

I TRIED BUT IT DINT WORK. IS THERE ANY OTHER WAY.

@Sanjeev7166 I wonder why "it din't work". What are you trying to do? Can you give an example or upload a file, indicating what you are trying to achieve?