Good day,
Can you please have a look at the Amount to Text funtion as it is adding the Word 'Million' incorrectly?
Can you please have a look at the Amount to Text funtion as it is adding the Word 'Million' incorrectly?
#40 Amount to Text - Adding a 'Million"
Posted in ‘Ian's Excel Add-in’
This is a public ticket
Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.
Latest post by on Monday, 03 November 2025 03:00 SAST
Monday, 15 September 2025 22:07 SAST
Ian
Hi Sumé,
Thank you for reporting this issue with the AmountToText function. I’ve tested it on my end using various inputs, but I haven’t been able to replicate the behaviour you're seeing. To help investigate further, could you please provide the following details:
-
The exact number or formula you're using with the function.
-
The output you're seeing, and what you would expect instead.
-
Whether you're using Excel in a different language or regional format (e.g., German, French, etc.).
-
If possible, a sample workbook or screenshot showing the issue.
Once I have this information, I’ll be able to dig deeper and provide a fix or workaround.
Kind regards,
Ian
Tuesday, 16 September 2025 08:20 SAST
sumeR
Good dya Ian,
Please see below informaiton as requested.
The exact number or formula you're using with the function. -Value of F5 [ 58 078.45 ] formula in G5 =amounttotext(F5). The text the formula is returning is "Fifty Eight Million Seventy Eight Thousand Forty Five"
The output you're seeing, and what you would expect instead. - "Fifty Eight Thousand Seventy Eight "
Whether you're using Excel in a different language or regional format (e.g., German, French, etc.).
If possible, a sample workbook or screenshot showing the issue. -Attached
Please see below informaiton as requested.
The exact number or formula you're using with the function. -Value of F5 [ 58 078.45 ] formula in G5 =amounttotext(F5). The text the formula is returning is "Fifty Eight Million Seventy Eight Thousand Forty Five"
The output you're seeing, and what you would expect instead. - "Fifty Eight Thousand Seventy Eight "
Whether you're using Excel in a different language or regional format (e.g., German, French, etc.).
If possible, a sample workbook or screenshot showing the issue. -Attached
Friday, 03 October 2025 15:22 SAST
Ian
Thank you for submitting the Excel file — I’ve reviewed it, but I wasn’t able to reproduce the issue on my system. One possibility is that the number format on your computer is different from mine due to regional settings (for example, how commas and decimal points are used).
To help me see exactly what you're seeing, could you please send a screenshot of the cell showing the incorrect result? This will let me view the number in its native format on your machine, which is important for understanding how the function is interpreting it.
You can take a screenshot by pressing Print Screen or using Snipping Tool, then paste it into your reply or attach it to the ticket.
Once I have that, I’ll be able to investigate further and work toward a fix.
Best regards,
Ian
Monday, 03 November 2025 03:00 SAST
System Task
system
This ticket has been automatically closed.All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.