Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unable to line up decimal points in some columns.
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Newbie question Different decimal place values for columns | Excel Worksheet Functions | |||
Joining data points on a line chart | Charts and Charting in Excel | |||
why 2003 excell does not accept dot as decimal points | Excel Discussion (Misc queries) | |||
Scatter chart with columns instead of points | Charts and Charting in Excel | |||
create space in line chart between points, linked to pivot table | Charts and Charting in Excel |