Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

? to align decimals when we centre the text in a cell 10.1, 100.1

Discussion in 'Information Technology' started by Ramesh Babu, Jul 28, 2006.

  1. Ramesh Babu

    Ramesh Babu
    Expand Collapse
    Guest

    I am not able align the decimal places when I centre the text in a cell. Is
    it possible to align number 10.1, 100.1, 1000.1 to the centre of the cell in
    a column as well as ensuring the decimals are aligned?
     
  2. Loading...


  3. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    I don't believe that option's available in Access.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no private e-mails, please)


    "Ramesh Babu" <Ramesh Babu@discussions.microsoft.com> wrote in message
    news:3194185D-E4BD-42DD-AAF9-D20973396092@microsoft.com...
    >I am not able align the decimal places when I centre the text in a cell. Is
    > it possible to align number 10.1, 100.1, 1000.1 to the centre of the cell
    > in
    > a column as well as ensuring the decimals are aligned?
     
  4. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    Re: ? to align decimals when we centre the text in a cell 10.1, 10

    Try this --
    Right(Space(5) & Left([YourDate],InStr([YourDate],".")-1),6) & "." &
    Right([YourDate],Len([YourDate])-InStr([YourDate],"."))

    You will need to set the font as Courier so that all characters use the same
    horizontal spacing.

    "Douglas J. Steele" wrote:

    > I don't believe that option's available in Access.
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no private e-mails, please)
    >
    >
    > "Ramesh Babu" <Ramesh Babu@discussions.microsoft.com> wrote in message
    > news:3194185D-E4BD-42DD-AAF9-D20973396092@microsoft.com...
    > >I am not able align the decimal places when I centre the text in a cell. Is
    > > it possible to align number 10.1, 100.1, 1000.1 to the centre of the cell
    > > in
    > > a column as well as ensuring the decimals are aligned?

    >
    >
    >
     
  5. Terry Kreft

    Terry Kreft
    Expand Collapse
    Guest

    Of course it isn't possible.

    Either you have to use padded strings with a non-proportional font or you
    have to choose how you want to align the data.

    --

    Terry Kreft


    "Ramesh Babu" <Ramesh Babu@discussions.microsoft.com> wrote in message
    news:3194185D-E4BD-42DD-AAF9-D20973396092@microsoft.com...
    > I am not able align the decimal places when I centre the text in a cell.

    Is
    > it possible to align number 10.1, 100.1, 1000.1 to the centre of the cell

    in
    > a column as well as ensuring the decimals are aligned?
     

Share This Page