Re: Scientific Notation in Text Cell after Fill

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: PegL (anonymous_at_discussions.microsoft.com)
Date: 03/04/04 

Date: Thu, 4 Mar 2004 05:38:04 -0800

Add a line above the one you have that says
myCell.NumberFormat="@"
I have XP, but I believe that will also work in 97.
>-----Original Message-----
>Using Office 97
>
>After using in a Sub Routine:
>
> myCell.FormulaR1C1 = myCell.Offset(-1, 0).FormulaR1C1
>
>Cells with 10+ numeric characters are displayed
>with Scientific Notation even though the Cell Format
>is "Text" which is the format that I want in this case.
>
>In Excel, if I select the cell AND click in the Formula
Box
>then the display of the cell changes instantly to a
normal
>text display, i.e., left aligned with no scientific
>notation.
>
>I did attempt to record a macro and used the code by
>placing it in my Sub Routine but still Scientific
Notation.
>
>In VBA, what can I do to properly display a "text" cell?
>
>TIA Dennis
>
>.
>

Relevant Pages

  • Re: help collecting data.
    ... Dim GetC As String ... the code in the cell that I want the order numbers(info from column C ... "Otto Moehrbach" wrote: ... display them both, seperated by a comma ...
    (microsoft.public.excel.misc)
  • RE: Create a "cell button" to hide selected cells.
    ... What I'd like to do, however, is to select a range of columns to display so I ... Dim intPickMonth As Integer ... Create a ComboBox on Cell A1 ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Visio 2007 visEquivTitle
    ... then the display is probably just turned off. ... Microsoft Certified Technology Specialist - Visio 2007 Applicaiton Development ... There is a function called 'tooltip' that works with a standard drawing. ... You can add the User.visEquivTitle cell to your shape and provide a string ...
    (microsoft.public.visio.general)
  • Re: Displaying formulae changes formatting
    ... "macropod" wrote: ... result for a given cell. ... With the macro I posted, you can display both the formula and it's result, ... Set CommentRange = Range ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Email Booster from Excel
    ... You can use Display instead of Send and then attach the file you want. ... Dim cell As Range ... Set OutApp = CreateObject ... 1.Instead of yes/no in criteria I wanted have it compared with date if the date and time matches to todays date and time then "yes" else no. ...
    (microsoft.public.excel.programming)