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)