guys, I really appreciate all the responses, but I had mentioned that the email generation is a automated process without any human intervention. Data is exported and email on an event daily int he morning. So the point of copy pasting and opening is not an option for me. I I click that little green devil, I know how to change the text as number, but the real solution that I require is how to put the values as a number in the first place.
Thanks and regards, shez. On Dec 23, 7:36 pm, "sarfaraz ahmed" <findsarfa...@gmail.com> wrote: > 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 > <davebonall...@hotmail.com>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: justsh...@gmail.com > > > To: excel-macros@googlegroups.com > > > > 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- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---
