rowdy_90
2

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
Ravi_gupta05
17

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)

Ravi_gupta05
17

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
rowdy_90
2

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
Ravi_gupta05
17

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.