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
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, 1405 views)

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
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 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
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.