Hi all, Please help me , how to convert a numeric into text in openoffice.org. (i.e Rs 758 is to be convert into text as seven hundred and fifty eight rupees only). Please reply... regards renuka
From India, Bangalore

Hi Renuka Find attachment of Excel Sheet , use this sheet for numric to text Ravi
From India, Gurgaon
Attached Files (Download Requires Membership)
File Type: xls how to convert a numeric into text in openoffice.xls (48.5 KB, 1409 views)


Hi Sushmita,

Write a number like 678.5 anywhere in an Excel sheet. Then, put the = sign with SP using Ctrl + Tab where you want to convert this number into text. Select that number and press Enter; you will see the number in text format.

From India, Gurgaon

Hi ravi, You mean you need to type these entries in ur attached excel sheet .. Because i tired it my excel but it wouldnt work.. And sushmita whether you tired it
From India, Bangalore

Hi Renuka,

Yes, of course, you need to transfer your data into my Excel sheet. Alternatively, you need to create a VB Module in your sheet. For this, you will have to write a program in the VB module and save it as a Microsoft Office Excel Macro-Enabled Worksheet.

From India, Gurgaon

Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.