Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Simply Accounting export to excel showing as text
07-08-2011, 09:40 AM
Post: #1
Simply Accounting export to excel showing as text
I exported reports from Simply Accounting to excel and the numbers are showing as text. This happens in both excel 2003 or excel 97-2003 formats. I tried reformatting these cells to numbers but they don't work. Is there something I am doing wrong?
Find all posts by this user
Quote this message in a reply

07-13-2011, 02:33 PM
Post: #2
RE: Simply Accounting export to excel showing as text
Here is the two step method I use when exporting simply accounting files to excel.
1. Try exporting it to a .csv format, and the cells will show numbers.
2. Then save it to an excel file.
It works!!!
Quote this message in a reply
07-16-2011, 10:25 AM
Post: #3
RE: Simply Accounting export to excel showing as text
Thank you.ShyShyHeart
That makes life a lot easier.
I was exporting the balance sheet and income statement to an excel file so that I can edit the fonts and make the report pretty.
Find all posts by this user
Quote this message in a reply
02-16-2012, 10:11 AM
Post: #4
RE: Simply Accounting export to excel showing as text
If you want to exporting the excel files. There are two steps to export files to excel...First try to exporting it to a.csv format..and after that cells wll show the numbers,if not there is a problem in exporting.. And second is save it to in excel file...

Excel courses sydney
Find all posts by this user
Quote this message in a reply
09-19-2012, 05:13 AM
Post: #5
RE: Simply Accounting export to excel showing as text
I can't tell you any sure tip because i am not understand you are telling about which numbers? so can you tell me in detail??

business coaching training
Find all posts by this user
Quote this message in a reply

05-01-2013, 06:45 PM
Post: #6
RE: Simply Accounting export to excel showing as text
I had some problem with Marida. I highly appreciate the way of Ginger. I exported it to a .csv format, and the cells will show numbers. and save it to an excel file
Find all posts by this user
Quote this message in a reply
07-30-2013, 12:52 PM
Post: #7
RE: Simply Accounting export to excel showing as text
hey thanks Ginger. you made it easy. mine was the same problem as i am new to it so didn't know much about it. thanks for the help.
Find all posts by this user
Quote this message in a reply
06-24-2014, 05:18 AM
Post: #8
RE: Simply Accounting export to excel showing as text
Very good and informative exchange .. Thank you!

dubli
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 2 Guest(s)