No Tags Found!


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
Acknowledge(0)
Amend(0)

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)

Acknowledge(0)
Amend(0)

Hi Sushmita
Writ number like 678.5 anywhere in excel sheet and then , put = sign with SP with ctrl+ Tab where you want to convert this number in to text select that number and enter , you will see number in text format

From India, Gurgaon
Acknowledge(0)
Amend(0)

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
Acknowledge(0)
Amend(0)

Hi Renuka
Yes of course, you need to transfer your data in my excel sheet,
Or you need to make a VB Module in your sheet for that you need to type a program in vb module and save as Microsoft Office Excel Macro-Enabled Worksheet

From India, Gurgaon
Acknowledge(0)
Amend(0)

Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.