aligning dates

V

vivek

I have dates in the format yyyy mmm dd. If I use a font like Arial the days(dd portion) don't line up. How can I align them without using a fixed width font; maybe via number formatting codes?

2004 Sep 01
2004 Jul 01

Vivek
 
D

Don

Hi Vivek,

One way, but it seems like monkey motion for little or
nothing gained.....

Put your three bits of data (yyyy,mmm,dd)in different
colums, then with a bit of formatting you should be able
to align them.

-----Original Message-----
I have dates in the format yyyy mmm dd. If I use a font
Click to expand...
like Arial the days(dd portion) don't line up. How can I
align them without using a fixed width font; maybe via
number formatting codes?
 

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 dates 4
How to add day to PWA 2016 date format? 0
Publisher is filling blank lines with data 2
Date Format - simple question 1
Dates Challenge 0
How to change font & size of (all) citation numbers? 7
Date Format 10
Forcing a date entry format of dd/mm/yyyy 1

Top