A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Alignment



 
 
Thread Tools Display Modes
  #1  
Old February 10th, 2004, 05:05 AM
external usenet poster
 
Posts: n/a
Default Alignment

Thanks Frank - your solution works a dream

Steven.
-----Original Message-----
Hi Steven
try the following custom format
0.????
use as many '?' as you have digits left from the decimal

place

Frank


Steven Ridley wrote:
Hello All,

I am creating a worksheet that has decimal values. I
would like to know if there is a way to align the

values
in the column so that the decimal place (.) are all
aligned no matter how many vaules are on each side of

the
decimal place - for example:

239.0
30.25
111.2

Thanks in anticipation of assistance with this matter.

Steven.



.

  #2  
Old February 10th, 2004, 09:15 AM
Frank Kabel
external usenet poster
 
Posts: n/a
Default Alignment

Hi Steven
thanks for the feedback
Frank

wrote:
Thanks Frank - your solution works a dream

Steven.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:35 AM.


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