Hello, If you have green mark due apostrophe than this link can be helpful.
How to remove apostrophe<http://findsarfaraz.blogspot.com/2008/09/how-to-remove-apostrophe.html> Regards, Sarfaraz On Fri, Dec 19, 2008 at 8:02 PM, Dave Bonallack <[email protected]>wrote: > Hi, > Not sure if you can use this, but the following is what I do to get around > the importing of formats. > Import the data initially to a spare sheet. > Then copy all data, and use Paste Special, Values to paste the data into > the intended sheet. > The intended sheet retains all its original formatting. > Hope this is helpful. > Regards - Dave. > > > Date: Fri, 19 Dec 2008 05:07:48 -0800 > > Subject: $$Excel-Macros$$ NUMBER STORED AS TEXT > > From: [email protected] > > To: [email protected] > > > > > > HI GUYS, > > I AM FACING A LITTLE PROBLEM HERE. I HAVE AN APPLICATION THAT EXTRACTS > > DATA FROM THE DATAWAREHOUSE AND EMIAL THE DATA CONTENTS TO THE END > > USERS BY EXPORTING THE DATA INTO EXCEL SHEETS.The problem starts here, > > there are some null values in the data and they are replaced by a 0 > > (zero) at the report level and when the other application tries to get > > the data from the reports, the seo stays there but the format changes > > to text and the little green devil appears. No I have tried the > > following things: > > - writing a macro and disabling the error checking > > (not good approach as the end user still cant use that column in > > addition etc) > > ( Also I dotn want the users to see the macro dialogue popup and they > > might think I am trying to hack into their system) > > - I have tried disabling the error option but that doesnt work. > > - I have tried to set the format of the template file and set the > > format of all the cells as NUMBER but doesnt work. > > > > Please help mein this regard. The problem should be fixed in a single > > template file and the same file is being used by 20 reports that are > > to be mailed to the business users on daily basis. I know this is a > > small issue, but still, CLIENT IS A CLIENT :P > > > > Please help me. > > Regards, > > shez. > > > > > > -- Thanks with regards, Sarfaraz Ahmed --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
