While the files are being imported from tally from versions 6.3 to 7.2 to excel some cells will be in the text format, which cannot be utilized for calcuation. Is there any way to convert this text numbers to number formats.
Menu
can the text format of numbers be converted to numbers
Replies (3)
when u open the text files in excel and selected the fields, select the same with the format as numbers
| Suppose the number is "234512.45" and the problem is that i have to convert it into words in "MS Excel 2007" like this "Rupees Two Lac Thirty Four Thousand Five Hundred Twelve and Fourty Five Paise" |
| Originally posted by :Guest | ||
| " | Suppose the number is "234512.45" and the problem is that i have to convert it into words in "MS Excel 2007" like this "Rupees Two Lac Thirty Four Thousand Five Hundred Twelve and Fourty Five Paise" |
" |
Download one very nice & small addins "Indian Rupees" TO CONVERT AMOUNT INTO WORDS by Shailesh from below page.
http://in.geocities.com/shahshaileshs/
Sachin
Recent Topic
- My client missed to file ITR 3 for AY 25-26
- Subscription/Membership fees
- Inverted tax gst refund
- Mismatch of pincode and district while registering
- Total income less than 12 lakhs but after processi
- Is Getsvision Solutions right for SMTP bulk email
- Queries on Stock/ETF gifting.
- Adding bank account for the deceased for ITR refun
- SALE OF EQUITY ON THE LAST DAY OF THE FY 2024-25 N
- Which ITR form
Related Topics
CAclubindia
