Convert Numeric To Text In Openoffice.calc - XLS Download

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
8th February 2012 From India, Bangalore

Hi Renuka Find attachment of Excel Sheet , use this sheet for numric to text Ravi
8th February 2012 From India, Gurgaon

Attached Files (Download Requires Membership)

how to convert a numeric into text in openoffice.xls (48.5 KB, 1401 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
9th February 2012 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
9th February 2012 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
9th February 2012 From India, Gurgaon