Re: Excel 2007 Replace and single quotes... bug!

Tech-Archive recommends: Speed Up your PC by fixing your registry

"Bob Flanagan" <noreply@xxxxxxxxxxx> wrote in
news:zfednTYJguLOYCXbnZ2dnUVZ_tKinZ2d@xxxxxxxxxxx:

Just a thought: change all single quotes to "zzzzz". Then change the
format to text and change the "zzzzz" to nothing.

Bob Flanagan
Macro Systems
http://www.add-ins.com

That's an interesting approach, and it will probably work. It just seems
kind of klugey.

The fact that Excel tells me "12 changes made" and yet it doesn't change
anything, and if I do the change over and over, it will tell me "12 changes
made" over and over, and yet not change anything... this has to be a bug in
Excel 2007.

David
.

Relevant Pages

  • RE: Excel & MS Query caused compile errors
    ... My data is in an Excel file called ... The format of it were distorted after copying and pasting. ... Microsoft SQL Server 2000, which requires a server, VBA or Microsoft Query ...
    (microsoft.public.excel.programming)
  • RE: Export to Excel: 2nd, 3rd, etc excel files not opening up
    ... early bindings to use the built-in functions of excel to format my excel ... Well based on your suggestions my understanding is that in my early binding ... Set xlApp = New Excel.Application ... I also was able to format that same exported excel ...
    (microsoft.public.access.formscoding)
  • RE: Get parameter dates in heading
    ... And if it goes in Excel where do you put it. ... Const conLightGray As Long = 12632256 ... Dim varGetFileName As Variant 'File Name with Full Path ... Dim strLeftRange As String 'Used to format range references ...
    (microsoft.public.access.externaldata)
  • Re: Dragging data to Excel using DoDragDrop
    ... It just puts a "biff8" object into the clipboard, ... object into Excel. ... if you can use a native Excel data format from ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Text formatted cells displaying numbers in scientific format
    ... If Excel is, indeed, 'trying to be helpful', it's not doing a good job ... distinguishes the data in question from any other numeric string, ... has the cell display the value in line with it's format (i.e. ...
    (microsoft.public.excel)