mannir muhammad
New Member
- Joined
- May 14, 2023
- Messages
- 10
- Office Version
- 2021
- Platform
- Windows
Wnich fomuler i will use to convert a number value into a text, 1000 to one thousand as text??
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How to convert a number value
- Thread starter mannir muhammad
- Start date
Excel Facts
How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
alansidman
Well-known Member
- Joined
- Feb 26, 2007
- Messages
- 8,111
- Office Version
- 365
- Platform
- Windows
You will need VBA to do this.
support.microsoft.com
Convert numbers into words - Microsoft Support
Discover how to convert numbers into English words in an Excel spreadsheet using the SpellNumber sample function.
support.microsoft.com
Upvote
0
Solution
mannir muhammad
New Member
- Joined
- May 14, 2023
- Messages
- 10
- Office Version
- 2021
- Platform
- Windows
Thank u sir, greatYou will need VBA to do this.
Convert numbers into words - Microsoft Support
Discover how to convert numbers into English words in an Excel spreadsheet using the SpellNumber sample function.
Upvote
0
Peter_SSs
MrExcel MVP, Moderator
- Joined
- May 28, 2005
- Messages
- 63,880
- Office Version
- 365
- Platform
- Windows
The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.
Upvote
0
