Solved: BOOKMARKS & DECITABS

[Greg]

Hi everyone,

With a Userform and bookmarks I insert dollar amounts into a table.

Unfortunately, the inserted amounts do not align with other amounts in rows above and below them, even though decitabs have been set in all the rows.

Does anyone have a cure for this?

[TrippyTom]

In order for decimal tabs to line up, you have to have all the table cells left aligned. If they're centered or something, they will go all sorts of directions.

If it's already left aligned, I'm not sure what else it might be.

[MOS MASTER]

Hi, :hi:

This is how you should do it to make sure they align arround the decimal point:

* First put your cursor in the table cell you want the decitabs
* Press the tabmarker on the left of your screen and set it to decitabs.
* Now point your cursor to the ruler (above the document) let's say in the middle of the table cel you want the decimal tab in. (the tab will be visible on the ruler)
* Put the cursor back in the table cell and pres CTRL+TAB to go to the decitabs location in your cell. (Rember normal TAB brings you to the next cell in a table)
* Now you can enter you're decimal values.

If I do it this way al is always aligned exactly at the decimal point.

HTH.:whistle:

[Greg]

Many thanks. Problem solved.

[MOS MASTER]

You're Welcome! :beerchug: