Yes it possible, but there is macro for it. the numbers can go into billions to. But there is NO formula for it. Let me find the macro and give it to you.
On Sep 13, 12:54 pm, "ankit varshney" <[EMAIL PROTECTED]> wrote: > Is it possible to convert any number in text. > > For Example if i entered 500 then by any folmula can excel can give output > of five thousend. > > -- > Ankit Varshney > 9210639227 --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---