Hi, when i click export button from sales invoice and copy data to google sheet the base currency symbol is taken as plain text for the sales invoice amount. If i delete the currency symbol manually then its taken as number/ value format Observer cell G7 and orange mark at top left of the pictur…

sorry i didnt see the other post about this topic. [image] How to do data analyis is excel with basic currency symbol I am liking Manager IO, I have been doing research (playing manger Io for about 6 months after purchase of cloud, and started using in my company for ab…

Doesn’t Google Sheets have a Find & Replace feature ?

it does, if its naira i can use find and replace option if its usd, find and replace showing me around 12 matches which includes customer names and description. Its not big deal. but looking for easy solution.

You have to think that Manager is supposed to cater for all the currencies of the world. The 2007 version of excel gave me the same problem with INR sign, so i started using Libre Office. Your problem is more dependent on the spreadsheet software.

Issue while exporting data to excel

raj_nann January 25, 2018, 12:49am 2

sorry i didnt see the other post about this topic.

But any solution using google sheets?

Topic		Replies	Views
Problem in Exported Data in Excel	9	938	November 8, 2017
How to do data analyis is excel with basic currency symbol	10	1493	December 6, 2017
Excel friendly	3	680	September 16, 2017
Multi currency symbol not displaying on payment/receipt edit screens	4	1263	July 9, 2020
Data export	2	843	July 6, 2016

Issue while exporting data to excel

Related topics