Format handling error

Format handling error

Hi,

I'm having an issue when merging a document using a custom function when with decimal numbers. In my template preview, it's seems correct ,but when I do the merge and attach the file to a record, all types of docs aren't displaying the number correctly.

This is my preview and as you can see, it displays the number correctly in both cases, the number to words function and the number format.


And this is my attached file (sample) when I run the custom function. As you can see, the number to words and the number format aren't handling the decimal part well.



In my custom function, I tried sending the data in different formats—text, number, and decimal—but I haven't been able to solve the problem.

Thanks

    Access your files securely from anywhere






                  Zoho Campaigns Resources


                        Zoho Developer Community



                            Bootcamp
                            Community
                            Pricing
                            Webinars
                            What's New
                            Integrations
                            Contact Support
                            Contact Sales

                              Zoho Survey Resources
                                Features
                                Survey Templates
                                Integrations
                                Community
                                iOS Mobile Surveys
                                Pricing
                                Android Mobile Surveys
                                Insurvey Blogs
                                Insight Blogs
                                Tips & Tricks





                                            Latest Feature Updates
                                              What's New in Zoho Desk

                                              Use cases

                                              Make the most of Zoho Desk with the use cases.

                                               
                                                

                                              eBooks

                                              Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho Desk.

                                               
                                                

                                              Videos

                                              Watch comprehensive videos on features and other important topics that will help you master Zoho Desk.

                                               
                                                

                                              Webinar

                                              Sign up for our webinars and learn the Zoho Desk basics, from customization to automation and more

                                               
                                                
                                              What's New in Zoho Desk

                                              • Desk Community Learning Series


                                              • Meetups


                                              • Ask the Experts


                                              • Kbase


                                              • Resources


                                              • Glossary


                                              • Desk Marketplace


                                              • MVP Corner



                                                  Zoho SalesIQ Resources

                                                        • Sticky Posts

                                                        • Deprecation of certain URL patterns for published Zoho Writer documents

                                                          Hi Zoho Writer users! We'd like to let you know that we have deprecated certain URL patterns for published and embedded documents in Zoho Writer due to security reasons. If the published or embedded documents are in any of these URL patterns, then their

                                                        • [Announcement] Insert image from URL changes in Zoho Writer

                                                          Hi Zoho Writer users! We'd like to let you know that we've changed the behavior of the Insert image from URL option in Zoho Writer for security reasons. Earlier behavior Once you inserted an image URL in a Writer document, the image would be fetched from

                                                        • Introducing plagiarism checker in Zoho Writer

                                                          Zia, Zoho Writer's AI-driven writing assistant, now highlights plagiarized and duplicated content in addition to offering contextual grammar and writing suggestions to help you write clearly and concisely in English. Zoho Writer's plagiarism reports Here

                                                        • [Important announcement] Impact of Google's new email guidelines for Zoho Writer automation users

                                                          Hi users, Google has recently announced new guidelines for sending emails to Gmail and other Google-hosted domains. These guidelines will be effective starting Feb. 1, 2024, and can impact the delivery of emails sent from Zoho Writer. Your organization

                                                        • Transitioning from MS Word to Writer: A complete walkthrough

                                                          Hello everyone! We understand moving to a new word processing tool can be difficult, especially if it means switching from a legacy software like MS Word. That's why we've organized an exclusive webinar where we talk you through ways to make your switch from MS Word to Writer as easy as possible. In this webinar, you'll learn: - Why Writer is a simple yet powerful alternative to MS Word. - How to locate your favorite MS Word features and functions in Writer.  - How to migrate your Word documents


                                                        Manage your brands on social media
                                                        Access Zoho Social

                                                          Zoho Pagesense Resources


                                                              Zoho TeamInbox Resources

                                                                Zoho DataPrep Resources


                                                                  Zoho CRM Plus Resources

                                                                    Zoho Books Resources


                                                                      Zoho Subscriptions Resources

                                                                        Zoho Projects Resources


                                                                          Zoho Sprints Resources


                                                                            Qntrl Resources


                                                                              Zoho Creator Resources



                                                                                  Zoho CRM Resources

                                                                                  • CRM Community Learning Series

                                                                                    CRM Community Learning Series


                                                                                  • Kaizen

                                                                                    Kaizen

                                                                                  • Functions

                                                                                    Functions

                                                                                  • Meetups

                                                                                    Meetups

                                                                                  • Kbase

                                                                                    Kbase

                                                                                  • Resources

                                                                                    Resources

                                                                                  • Digest

                                                                                    Digest

                                                                                  • CRM Marketplace

                                                                                    CRM Marketplace

                                                                                  • MVP Corner

                                                                                    MVP Corner







                                                                                      Design. Discuss. Deliver.

                                                                                      Create visually engaging stories with Zoho Show.

                                                                                      Get Started Now


                                                                                        Zoho Show Resources


                                                                                          Zoho Writer Writer

                                                                                          Get Started. Write Away!

                                                                                          Writer is a powerful online word processor, designed for collaborative work.

                                                                                            Zoho CRM コンテンツ






                                                                                              Nederlandse Hulpbronnen


                                                                                                  ご検討中の方




                                                                                                        • Recent Topics

                                                                                                        • TDS Filing

                                                                                                          Is there any option for automatic 26Q and 24Q filing in Zoho books. Even Tally has this option. Why don't Zoho has this ? Is there any customisation available for this ?

                                                                                                        • Adding bank details to the contact through API

                                                                                                          How to add bank-related information to the contact while creating it using API? The account number needs to be encrypted before sending it through API but not sure how to encrypt and get those values. Please guide me in this.

                                                                                                        • average cost display

                                                                                                          Hello there, I'm using the average cost valuation method, and the cost price shown in the Items menu should reflect the latest WAC (Weighted Average Cost). However, it doesn't update automatically. Is there a way to display the current average cost without

                                                                                                        • Apple Mail issues

                                                                                                          Dear Sir or Madam, I am trying to configure my Zoho mail account to Apple Mail. It is not working. It seems to need more information (perhaps a path prefix?) than is shown in your tutorial (<www.zoho.com/mail/help/apple-mac-imap.html>). After plugging

                                                                                                        • Assistance Required for Migrating Data from Odoo Inventory to Zoho Inventory

                                                                                                          Hi Team, I previously used Odoo Inventory to manage my stock and transactions, and I’ve now moved to Zoho Inventory. I’d like to migrate my data from Odoo—including product details, stock, purchase, and vendor information- into Zoho Inventory for continuity

                                                                                                        • I need my entire Zoho Account (mail/organization) deleted!

                                                                                                          Hey! I used zoho for my email aaron@aaronglass.me with domain forwarding/mx all that. I got rid of the mx info on my godaddy account and still Google won't let me sign up with my aaron@aaronglass.me email. (I'm moving to Google for business) SO! I was

                                                                                                        • Error: "Invalid Element warehouse_id" when sending order to Zoho

                                                                                                          i'm getting the error "Invalid Element warehouse_id" when trying to send an order to Zoho via API. Has anyone faced this issue before? How can I fix it?

                                                                                                        • No way to sell individual and case units smoothly in Zoho

                                                                                                          Currently, Zoho Inventory handles inventory primarily at the case level, which can be challenging for businesses that frequently need to break down cases into individual units for retail sales or smaller shipments. Although Zoho Inventory currently supports

                                                                                                        • How to handle multiple languages (Resume parser, Job opening, job board, career site) ?

                                                                                                          We are looking to bring Zoho Recruit to a market that needs to support 2 languages. The first thing we need to make sure is that the Candidate be flag with the language they speak. This is easy enough make a custom field that as the desire languages.

                                                                                                        • Multi-Card Selection and Cross-Zobot Copy-Paste Functionality

                                                                                                          Dear Zoho SalesIQ Team, We’d like to suggest a productivity-enhancing feature for the Zobot builder in Zoho SalesIQ: the ability to select multiple cards (modules) at once using a selection area, and then copy-paste them either within the same canvas

                                                                                                        • Shipping Labels

                                                                                                          Hi, Can we generate Packing Labels for manual shipping same as the format as Airway Bill in zoho books or inventory?

                                                                                                        • Add a Way to Duplicate Cards in the Same Canvas (Retain All Settings)

                                                                                                          Dear Zoho SalesIQ Team, We would like to request a new feature in Zoho SalesIQ: the ability to duplicate an existing card within the same canvas while retaining all of its information and settings, including conditions, configurations, and display preferences.

                                                                                                        • Session "Ask Me Anything" Zoho France - Le 26 Juin 2025 14h à 17h (en Français

                                                                                                          Chers Utilisateurs, Vous cherchez à mieux comprendre Zoho CRM ou Zoho Desk ? Nos experts seront disponibles pour répondre à toutes vos questions lors de notre session Ask Me Anything. Rejoignez-nous ici pour en discuter en ligne. Pendant trois heures,

                                                                                                        • Managing two books in Zoho Books

                                                                                                          is it possible to effectively manage two separate books within Zoho Books? My organization is considering handling accounting for two distinct subsidiaries, and we would like to understand the best way to achieve this within the Zoho Books.

                                                                                                        • Unit Measurement Sign,

                                                                                                          Dear Zoho Support Team, I hope you are doing well. We recently purchased Zoho Inventory based on recommendations of your team that “it would be a great fit for our Shopify operations”. However, we are currently facing several urgent issues that require

                                                                                                        • Leadchain into a custom module

                                                                                                          Hello ZOHO Community ! is it possible to put the leads collected by leadchain into a custom module instaed of leads module ? Best wishes Niels

                                                                                                        • Urgent: How to Bulk Upload Images in Zoho Inventory? Any Workarounds?

                                                                                                          We are currently onboarding 5,000+ items from Shopify into Zoho Inventory, but we’re struggling with the lack of a bulk image upload feature. Right now, we have to manually upload and assign images one by one, which is extremely time-consuming and inefficient.

                                                                                                        • Can I automatically update COGS and Inventory account when creating an item?

                                                                                                          I have been trying to get Zoho to update the other two fields when I update one (Sales Account, COGS account, and Inventory Account). I know this seems like not a huge time saver, but I am all about efficiency and being an independent taproom, I create

                                                                                                        • I'm looking for a Microsoft List alternative in Zoho One to manage large lists of repetitive tasks

                                                                                                          I've used Microsoft Lists to manage lots of tasks that need to be completed several times for different users. We started with a large spreadsheet and then discovered lists, which worked pretty well. I was wondering if there is a similar products in Zoho,

                                                                                                        • Importing a contact with a linked product

                                                                                                          Hi, I'm trying to import my contacts from an excel spreadsheet and each of those contacts have fields that relate to products. Is there a way that I can import the contact with their linked product? Some of the contacts in my spreadsheet have multiple

                                                                                                        • Zoholics Europe and UK Awards 2025: Honouring our loyal customers!

                                                                                                          We're excited to announce that at this year's Zoholics events across Europe, we're holding customer awards for the first time ever! This is your chance to shout about the amazing things you've created, connected, or achieved with Bigin! And if you win,

                                                                                                        • Zoho Landing Page "Something went wrong" Error

                                                                                                          Hello, Every time I try to create a new landing page, I receive a "Something went wrong" error with no explanation. I cannot create any new pages, which means we cannot use this application. I did create one landing page successfully over a month ago,

                                                                                                        • CRM - Workflow Rules to be applied and work across modules

                                                                                                          Hello, It seems that you can't use workflow rules in CRM to work across modules, is this correct? I need a customer account status to be changed IF there have been no new deals or new quotes in the last 6 months. I can't see this is possible? I can create

                                                                                                        • Fillable template with dynamic tables?

                                                                                                          Is there a way to build a fillable template so that users can add rows to a table? To describe what I'm trying to accomplish the table has 3 sections; a header row, some number of rows with custom information, and a summary row with totals. I can't figure

                                                                                                        • How to store API keys in zoho?

                                                                                                          Hi everyone, I'm currently building an integration using Zoho Flow and I need to securely store several API keys that will be used to make external service calls from my flows. I would not like to hardcode the values in the code of custom function. What's

                                                                                                        • Zoho RPA is now available in your Zoho One bundle!

                                                                                                          Hello All! Of late, it's been quite a stint of new app integrations in Zoho One. This announcement pertains to the addition of another Zoho application, the most sought-after Zoho RPA - Robotic Process Automation, to the bundle. What is Zoho RPA? Zoho

                                                                                                        • Early Payment Discount customize Text

                                                                                                          Hi, I’m currently using Zoho Books and am trying to customize the standard “Early Payment Discount” message that appears in the PDF invoice template. I’ve reviewed the documentation here: https://www.zoho.com/books/help/invoice/early-payment-discount.html

                                                                                                        • Multi-currency in Zoho CRM Forecast and Reports

                                                                                                          As a company we have branches in 4 different countries with as many different currencies. Our Sales Teams would like to work with their local currency as much as possible. The Forecast module using only 1 currency is practically usable only by the sales

                                                                                                        • is there an easy way to embed a zoho analytics report into a widget (or inside the "account" page) of Zoho CRM

                                                                                                          Hi, I have built a report that is specific to an account in Zoho CRM but I would like this to be built into the Zoho CRM front-end. I have looked at the widget concept but it seems quite complicated (see attached screenshot but I need to filter this view

                                                                                                        • Zoho Notifications - Received two notifications for one message and none for the other

                                                                                                          We had a client reply to a ticket twice in one minute. The ticket owner received two emails for the second message but none for the first (which was crucial content and unfortunately was therefore missed). I'm assuming this created a race condition -

                                                                                                        • Bigin iOS app update - Introducing Card Scanner and initiating WhatsApp conversations using pre-approved templates.

                                                                                                          Hello everyone! In the latest iOS (v1.11.3) version of the Bigin app, we have introduced the following features: Card Scanner Initiating WhatsApp conversations. Card Scanner: Our new Card Scanner feature extracts contact information from business cards.

                                                                                                        • Introducing card scanner in Bigin Android app

                                                                                                          Hello everyone! We are excited to introduce the card scanner feature on the latest Android version(1.7.26) of the Bigin app as well. Card scanner extracts contact information from business cards and allows you to save them as contacts in Bigin. You can

                                                                                                        • Full RTL and Hebrew Translation Support for Zoho Creator User Portal (Including All System Pages, Templates, and MFA Screens)

                                                                                                          Dear Zoho Creator Team, We kindly request comprehensive support for right-to-left (RTL) languages, particularly Hebrew, across the entire Zoho Creator user portal. This includes system-generated pages, templates, and multi-factor authentication (MFA)

                                                                                                        • Auto assign account owner

                                                                                                          hi, i need to auto assign leads and accounts to an owner by rules. i have created all the territories i need, and all territories have their owner. but when i want to auto assign a new or an existing account to a user by the rules of territories, only

                                                                                                        • ZUG real estate virtual meetup 2025: Sign documents, collect payments, and automate workflows with Zoho Sign

                                                                                                          Hi there! Are you in real estate and looking for a secure, compliant way to manage all your paperwork? In such a fast-paced industry, timing, compliance, and client trust are everything. Handling paperwork has always been a challenge, whether you're finalizing

                                                                                                        • OCR (Optical Character Recognition), automatisation des PDF et autres améliorations de Zoho RPA

                                                                                                          Zoho RPA est une plateforme d'automatisation des processus robotiques conçue pour accélérer et simplifier vos workflows. Elle permet de connecter facilement vos applications cloud à vos systèmes existants, même ceux qui ne disposent pas d’API, afin d’automatiser

                                                                                                        • Multi-Select lookup field has reached its maximum??

                                                                                                          Hi there, I want to create a multi-select lookup field in a module but I can't select the model I want the relationship to be with from the list. From the help page on this I see that you can only create a max of 2 relationships per module? Is that true?

                                                                                                        • 📢 Boost Your CRM Communication with HelloSend – Now on Zoho Marketplace!

                                                                                                          We’re excited to introduce HelloSend, a powerful communication extension for Zoho CRM that brings SMS, WhatsApp, and Voice Calling directly into your CRM workspace. Whether you're in sales, support, or service delivery, HelloSend helps you connect with

                                                                                                        • Automation#24: Auto-Update custom field from Accounts to Tickets

                                                                                                          Hello Everyone! Welcome back to the Community Learning Series! This episode dives into how Zylker Techfix streamlines account-related ticket references. Previously, employees had to manually check account details to retrieve specific customer information,

                                                                                                        • Support Mixed Visibility Settings in Knowledge Base Categories

                                                                                                          Hello Zoho Desk Team, We hope you're all doing well. We’d like to submit a feature request regarding visibility settings in the Knowledge Base module. 🎯 Current Limitation As of today, when a category is set to a specific visibility level (e.g., Public),

                                                                                                        • Next Page