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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Aligning decimal numers to the centre of the cell and aligning dec 1
Aligning numbers to the centre of the cell 2
Decimal Point Vertical Alignment in Excel 2003 7
How to use decimal tab to align characters (i.e. column heading)? 2
What format symbols are used to center-align text in a datasheet? 16
How to Anchor Decimal in Text Box 1
How To Align Decimals In A PP 2007 Table 3
Entering left & right aligned, & centred text, into one merged cel 2

Back
Top