Professional Web Applications Themes

ASP IN EXCEL, trailing zeros being truncated - ASP Components

Hi, I have an asp file which opens in Microsoft Excel. I have used "FormatNumber" function to force variables I display to be a certain number of decimal places. However, Excel cuts off any zeros at the end. eg. the number 5.640 displays as 5.64, even though I used format continued...

  1. #1

    Default ASP IN EXCEL, trailing zeros being truncated

    Hi,

    I have an asp file which opens in Microsoft Excel.
    I have used "FormatNumber" function to force variables I
    display to be a certain number of decimal places.
    However, Excel cuts off any zeros at the end.
    eg. the number 5.640 displays as 5.64, even though I used
    format number to 3 decimal places.

    The number of decimal places I need to use throughout the
    page vaires, i.e I cant say "the whole page can be of 3 dp"

    How can I code the ASP page to stop Excel truncating the
    zeros at the end?

    Thanks very much for your help!
    Any advice is really appreciated

    Barbara
    BARBARA FLOYD Guest

  2. #2

    Default Re: ASP IN EXCEL, trailing zeros being truncated

    ~Try~ preceding the values with a ' in your response.

    Ray at home

    "BARBARA FLOYD" <anonymous@discussions.microsoft.com> wrote in message
    news:0bfa01c3a83c$158b4a20$a101280a@phx.gbl...
    > Hi,
    >
    > I have an asp file which opens in Microsoft Excel.
    > I have used "FormatNumber" function to force variables I
    > display to be a certain number of decimal places.
    > However, Excel cuts off any zeros at the end.
    > eg. the number 5.640 displays as 5.64, even though I used
    > format number to 3 decimal places.
    >
    > The number of decimal places I need to use throughout the
    > page vaires, i.e I cant say "the whole page can be of 3 dp"
    >
    > How can I code the ASP page to stop Excel truncating the
    > zeros at the end?
    >
    > Thanks very much for your help!
    > Any advice is really appreciated
    >
    > Barbara

    Ray at Guest

Similar Threads

  1. Replies: 2
    Last Post: June 16th, 12:55 PM
  2. Leading Zeros not being read from Excel Query
    By cmkelly in forum Coldfusion Database Access
    Replies: 2
    Last Post: October 18th, 08:33 PM
  3. Disappering leading zeros
    By elvis is dead in forum Macromedia ColdFusion
    Replies: 0
    Last Post: May 13th, 11:23 AM
  4. Insert leading zeros
    By Matt Palermo in forum PHP Development
    Replies: 2
    Last Post: July 16th, 12:48 AM
  5. CSV for Excel - Problem with Leading Zeros
    By Luke Zhang [MSFT] in forum ASP.NET General
    Replies: 0
    Last Post: June 26th, 01:34 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139