Category : Lotus and other Spreadsheets
Archive   : SRBMACRO.ZIP
Filename : DATE.WK1

'–*
'"/


ÿ


ÿ q H
A d GDATE

GDATEL

GNEXT

G\D

ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ
ÿÿÿÿÿÿÿÿÿÿ†ÿÿ±0
ÿÿÿÿÿÿÿÿì ÿÿÿÿ# ÿÿ
ÿÿ
gÿÿÿÿÿÿÿÿÿÿÿÿi(ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿfÿÿÿÿÿÿÿÿ$
%ò ** LATEST CONTROLS BY DUE DATE **|I:\GROUP\PBB\ASSIGNME.WK1|PAGE # &ò '( (
LB)
'*ÿÿÿÿÿÿÿÿ-·
ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿqq
 ÿ'\d5ÿ
'{GETLABEL "Enter date as (mm/dd/yy): ",DATEL}~)ÿ

'{IF @ISERR(DATE)}{beep}{BRANCH \d}ÿ
'/rvDATE~~/rfd4~ÿ
'{MENUBRANCH next}ÿ'NEXTÿ
'Enter another? ÿ'Rightÿ'Leftÿ'Down ÿ'Noÿ
'Please Chooseÿ'Move Right and continue.ÿ'Move Left and continue.ÿ'Move Down and Continue.ÿ'Quit Workingÿ
'{MenuBranch NEXT}ÿ'{RIGHT}{BRANCH \d}ÿ'{LEFT}{BRANCH \d}ÿ'{DOWN}{BRANCH \d}
ÿ'{QUIT} ÿ 'datelÿ
'09/15/88ÿ'dateÿ
@¤ß@
€þŸM
ùÀ£ß@Fÿ
'This macro will convert a date entered as MM/DD/YY to the LotusEÿ
'serial number so it can be used by the Lotus formulas and alsoGÿ
'formatted using the "/ Range Format Date" commands. By changingCÿ
'the "4" on the third line above to a "1", or "2", or "3" you<ÿ
'can change the format of the cell containing the dateÿ
'automatinally.?ÿ
'To invoke the macro hold down the macro key (Alt on most(ÿ
'computers) and press the "d" key.Fÿ
'If you combined this with another spreadsheet you will have to Dÿ
'name the column to the right of the \d. To do this place theAÿ
'cursor on the \d and press slash (/), Range (R), Name (N),Fÿ
'Lables (L), Right (R), Page Down and Enter. This will name theAÿ
'column to the right of the \d with the names in the column#ÿ
'with the names under the \d. ò
" ù" ù
$
ù
'Àpß@