I have only one other suggestion, but its kind of cheesy. If you have a
number in a cell, you can not format the individual digits with thier own
fonts. You can format the individual characters in text string separately.

You have to do this in the formula bar:

Select the cell with 051113 in it. In the formula bar, highlight 0511 and
pull-down:

Format Cells... Font and set the color to the same as the background
color. This will make the 0511 seem to disappear, leaving only the 13.
--
Gary''s Student


"nastech" wrote:

yes yymmdd, actually looks like not enough room to do, no space for more
columns, don't know if have suggestion for same cell.

"Gary''s Student" wrote:

Looking at your first problem I assume that 051113 means:
day 13
month 11
year 2005
and that all you text/dates are 6 characters. In a separate cell enter:

=right(A1,2) if the text/date in in cell A1. You can justify it anyway you
like.
--
Gary's Student


"nastech" wrote:

Date Format Problems??

Hi, I am a bit novice at some of this; any suggestions will help, (can
find/ using: format cells, number/custom.. cond. format..)

Date example that I was/ am using: Text: 051113, and "Right Justify" to
see just last 2 digits: 13 (for day)
I changed system date format in Control Panel, Regions, to be: yy-mm-dd
(did not really want dashes, trying for database type sorting of dates..?)
Don't know if I should pick a different format to do same thing.. to see:
yymmdd.

- Is there a work-around for seeing "text"? / last two characters of DATE?
When I format as a date, & narrow the column, & Right Justify (for space &
to see just the last 2 numbers), i get: ##
Trying to get ## to go away, and still be a date.


2nd problem: need Function for date older than 1 "Business" day. (for
Cond. Formatting), (note: for weekends-sat / sun, Friday is still today :)
is there a Date type Function to use?, Thanks, need something like:

IF( last "Business" DATE is one day old),true,false)