Unable to line up decimal points in some columns.

G

Guest

I'm trying to line up calender dates which are written in the following format:

1. 1
10. 5
23.12
5.11

So far I've managed to line up the decimal points without problems, though
now in some columns I've noticed that despite having formatted dates with 2
decimal places, when I click on certain cells, they get reduced, for example,
from 1.10 to 1.1. Also, if they start out as, say, 1.1 and I attempt to
change them to 1.10, the change takes place, but the numbers become right
justified. If I then attempt to left justify and line up the decimal points,
I find myself back to square one.

Can anyone help?

Regards,

Mikael
 
G

Guest

That's great! It worked. It means a few extra zeros, but I can live with that.

Thanks, Stefi.
 

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

Lining up decimal points with negatives in brackets 2
Suddenly unable to re-format cells 2
How to put names over columns and left-justify numbers or align decimal points 3
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Line Up Two Columns In Excel 2
Data exports 1
Data Points Filled In Blue Showing Up With A Red Circumferencial 3
Jet 4.0 DECIMAL type: VBA Decimal type and take up in Access 0

Top