In order to import data into an accounting program, the account number has to be formatted with an apostrophe at the front. I've tried formatting as text. I've tried ="'"&a1.
Other than manually adding it to each number, is there any way to add the apostrophe?
Here is the code...
Code assumes that account number to which you want to add apostrophe in the begenning is in Column A.
Change the code to meet your need.
Please Login or Register to view this content.
Shijesh Kumar
http://shijesh.wordpress.com/
The code seems to do the same as ="'"&A1 function. That leaves the apostrophe showing in the cell & that won't import.
you are probably trying to import the result of formula with formula still in cell
copy results paste back special /values
or are you saying you have to put the ' in to preserve 00077777 rather than displaying 7777?
something to try is
="'"&TEXT(A1,"0000000") where the number of zeros is equal to your number length
Last edited by martindwilson; 06-25-2008 at 10:38 AM.
yo I did it............
Assumption : data to which appos has to be added in in sheet 1 cell A1...
Please Login or Register to view this content.
Hi Shijesh, I appreciate you posting this answer, but I am new to Excel, and wanted to know if this is a macro? And if yes, how you enter it? Sorry for the stupid question.
Lilia
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks