LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Newbie question Different decimal place values for columns dan yemiola Excel Worksheet Functions 1 June 10th 06 08:18 PM
Joining data points on a line chart JCW173 Charts and Charting in Excel 2 January 26th 06 12:38 PM
why 2003 excell does not accept dot as decimal points miki Excel Discussion (Misc queries) 1 November 2nd 05 10:17 AM
Scatter chart with columns instead of points Bill_S Charts and Charting in Excel 1 October 7th 05 04:52 AM
create space in line chart between points, linked to pivot table Mike -Z- Charts and Charting in Excel 1 December 7th 04 09:39 PM


All times are GMT +1. The time now is 03:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"