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

Uncategorized

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 Uncategorized	9	956	November 8, 2017
How to do data analyis is excel with basic currency symbol Uncategorized	10	1504	December 6, 2017
Excel friendly Uncategorized	3	696	September 16, 2017
Multi currency symbol not displaying on payment/receipt edit screens Uncategorized	4	1269	July 9, 2020
Data export Uncategorized	2	847	July 6, 2016

Issue while exporting data to excel

Related topics