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

R

Ramesh Babu

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

KARL DEWEY

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

Terry Kreft

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
Excel does not accept text format! 0
Aligning numbers to the centre of the cell 2
Format column widths from one table to a separate table on same page 1
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Mail Merge - displaying a conditional number of decimals 5
Insert Index into a Table 1
How To Align Decimals In A PP 2007 Table 3

Top