masking expiration date on full page receipt

Does anyone have a full page receipt where the expirate date is masked out?
0
shawn1 (154)
6/26/2008 11:21:01 PM
pos 14173 articles. 0 followers. Follow

3 Replies
400 Views

Similar Articles

[PageSpeed] 19

hi yes I do have lot of formats, where and how I send as the outlook express 
newsgroup is not working at my place and I only use the web base newsgroup.
Akber

"Shawn" wrote:

> Does anyone have a full page receipt where the expirate date is masked out?
0
AkberAlwani (916)
6/30/2008 4:52:00 AM
Hi Akber,

Please contact me and I will provide you information to send me the receipt 
template.


=====================
Thanks,

Shawn Ezhaghi
Vitet Consulting Group Ltd.
646-706-7600 xt: 101

"Not just consultants but retailers too."


"Akber Alwani" wrote:

> hi yes I do have lot of formats, where and how I send as the outlook express 
> newsgroup is not working at my place and I only use the web base newsgroup.
> Akber
> 
> "Shawn" wrote:
> 
> > Does anyone have a full page receipt where the expirate date is masked out?
0
shawn1 (154)
6/30/2008 5:50:00 PM
This is a multi-part message in MIME format.

------=_NextPart_000_01E5_01C8DB88.BCAB5780
Content-Type: multipart/alternative;
	boundary="----=_NextPart_001_01E6_01C8DB88.BCAB7E90"


------=_NextPart_001_01E6_01C8DB88.BCAB7E90
Content-Type: text/plain;
	charset="utf-8"
Content-Transfer-Encoding: quoted-printable

Shawn,

Try this one, I just deleted the 2 lines.=20

--=20

Jeff=20
Check Point Software

Search this newsgroup -- http://tinyurl.com/2lmk4w  (Stolen from DRS)
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

You must be using Outlook Express/Windows Mail or some other type of =
newsgroup reader to
see and download the file attachment(s).  If you are not using a reader, =
follow
the link below to setup Outlook Express.  Click on "Open with =
newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D


  "Shawn" <Shawn@discussions.microsoft.com> wrote in message =
news:E174B3FB-F609-466C-84F6-0969240A75A3@microsoft.com...
  Does anyone have a full page receipt where the expirate date is masked =
out?
------=_NextPart_001_01E6_01C8DB88.BCAB7E90
Content-Type: text/html;
	charset="utf-8"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3Dtext/html;charset=3Dutf-8>
<META content=3D"MSHTML 6.00.6001.18063" name=3DGENERATOR></HEAD>
<BODY id=3DMailContainerBody=20
style=3D"PADDING-RIGHT: 10px; PADDING-LEFT: 10px; PADDING-TOP: 15px"=20
bgColor=3D#ffffff leftMargin=3D0 topMargin=3D0 CanvasTabStop=3D"true"=20
name=3D"Compose message area">
<DIV><FONT color=3D#008000>Shawn,</FONT></DIV>
<DIV><FONT color=3D#008000></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#008000>Try this one, I just deleted the 2 lines. =
</FONT></DIV>
<DIV><BR>-- <BR><BR>Jeff <BR>Check Point Software</DIV>
<DIV>&nbsp;</DIV>
<DIV>Search this newsgroup -- <A=20
title=3D"http://tinyurl.com/2lmk4w&#10;CTRL + Click to follow link"=20
href=3D"http://tinyurl.com/2lmk4w">http://tinyurl.com/2lmk4w</A>&nbsp; =
(Stolen=20
from =
DRS)<BR>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D</DIV>
<DIV>&nbsp;</DIV>
<DIV>You must be using Outlook Express/Windows Mail or some other type =
of=20
newsgroup reader to<BR>see and download the file attachment(s).&nbsp; If =
you are=20
not using a reader, follow<BR>the link below to setup Outlook =
Express.&nbsp;=20
Click on "Open with newsreader"<BR>under the MS Retail Management System =
on the=20
right.</DIV>
<DIV>&nbsp;</DIV>
<DIV><A=20
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A><BR>=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #008000 2px solid; MARGIN-RIGHT: 0px">
  <DIV>"Shawn" &lt;<A=20
  =
href=3D"mailto:Shawn@discussions.microsoft.com">Shawn@discussions.microso=
ft.com</A>&gt;=20
  wrote in message <A=20
  =
href=3D"news:E174B3FB-F609-466C-84F6-0969240A75A3@microsoft.com">news:E17=
4B3FB-F609-466C-84F6-0969240A75A3@microsoft.com</A>...</DIV>Does=20
  anyone have a full page receipt where the expirate date is masked=20
out?</BLOCKQUOTE></BODY></HTML>

------=_NextPart_001_01E6_01C8DB88.BCAB7E90--

------=_NextPart_000_01E5_01C8DB88.BCAB5780
Content-Type: application/x-zip-compressed;
	name="fullpage.zip"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
	filename="fullpage.zip"

UEsDBBQAAgAIANlu4Tg1JsY0PRUAAGgoAQAMAAAAZnVsbHBhZ2UueG1s7R1rTxtJcr5y0v2HWZ+0
Sm4VCCSs9rgkJzAhQTKBwyTZXZ1WIuAlKE5A2LCJFO1Pv7vq6mlPP2f6OR47IysBPD3VVV2Prq6u
rv7ff59k/8o+Zx+zcZZnd9kou8km2WV2lX2Cv5/Cv162nq1mD+FnDk8/ZWfw7BxafMouZi1eZyfZ
XvYAWv4If/0re5b9NftL9iT7Dr57AD/Xsp+zg2wA3+fZcfY868O//ewI3iLPWWvWhvxF/uX4eQLt
jrND+P85/DyB955nw6JVzn2eZLv4pA+tKOx9eOsV9kl6HQHmI8D7OpvC3w/g3152C1QTuo+yU6Bm
hFDWjHDUHreR8pfw/Ljop/wcQF9nMJpXMJ5X2e/Yax9+uwEMyP+n8A0b5xLimgRT7fMNjsNQoI59
3kj8o5zblDDTfUjPMmSeB2sVXOB5Xb7z1OtTvr8N4zMFai6zd8CnKVA2iQK9lDieviHQcwK/fQK+
fIS+noIcizJDeHcLz6eoCWfw+wR+v4LWpC3B9BbakmfniOsZ4n4947IKMZdgTrMv8D3t+w6oHuB7
F/CXyOV1LfcoBc9qqSKyfo1y8hbwOIde3wdQVELLJXgyNedI6zvQt5FCEfn8BLK6GUTPSxzZC+h/
GokiGaILTeuF9j10pOcAfr+BPomFHcB3vwdRw0PLBXiu/HnoyR8eg+MI/BEpOvbmTwx6TgD+dTRa
SmiuvIlFzw70My2oiEWVDNOWNl96iM6eInaxLAIP0d8mPOLocaNoDyBe4QwYiyIeoj9FG0DRhhdF
fcT3I/qTU7BKRFJGYC/9KRIh5jOYeQFVpmlY+Ba6+bUH+L4HbD9lH+CvL0h9DnbzCkdrAs+Inl7P
3g6nfCMJ5RvOlA+x9xtovQoeIMU6nLpHSah75MHXI5ThU+hrhBhdIeQcvf9TfOu7KPx8nITix1YU
h2O/mQT7zejYE//4Av7twftj7JE+88eeQcy1MGPiPkQr8gencfvwnNiYOuyr8GdQeU3OZ5pM1pbn
8LnB9ycFNJmqHZwbqJ58knTopMDD1d4zvPocXWTuUfHx41tJt9xDrunDluJQapns78LPCVobutaL
Q2mpWXr4LnwNp/UEvvsMmIyg31PUnThUUri5BrIbffxnD1qMiznAj9od9HBpJGwUhU4Voj99eVTO
MpsYR2ZLWLHoy6PaJ372imWRVJgxaA+ldRfevoY+SZTyFNcCMajVQ7WjN5SibeiztII7qOWnGLEe
JZtb+B5zqc9JA7SzWaCPMMmMH+L9sBlFhObiY9t+CJxfAOYY+/lDS3eauPIbtLSX8D9d0dK55Qz5
xkflm442sz0I9yiqLqJLdzh0sUT1SRlD84m9Epx9Igj6uK2KHY2Kqd/zcSX61BT5Ybs9+iiKTuqq
aH4FP+ttjTwCRCNv0Aslbb7MRuFhY3Jf7nEN0ZeaFhqcUs4PYJyOsxewttHvn/VxR4ntJbHvTfsu
fKRJfFOFfILP1T05Va5+qJQccY+FQVX724EnJ/j8gOvVLK8/VEhk2Z8IVe11APTvodyYqCy1XqSk
fFOFSvY9XwBGIlyzxSih8m+qcA/x+XOQhROQi3JflcwzR/j/FC3wZaGVpvbivqQqY2n0Zw9nhelc
5os9pFy2RD3tKL+C8TiAUZNjX9vFrDcu1v2yRJTvqTDJnvCvCsx1tF7Ve8rlm3qdGcBoPqtYnelg
lu+pMF8DHbu4Rz1AiaA418PUvadC30dJJC36HNb10MX39HZwoGQRUG+RyNkZRqJVuPx7olYwiXlm
IUdD+O0UPbFOojqJiiFRg2KuGLVAon6KLk/8Wq2Tpybk6SWMdxuk6VH2YydNSaWJ+P7nQZKUxvvj
Vwjx/Twib6+Bz6LU76J/+YfQd0/jHZKx3kGPXn6mroZ0K6DqlU05urlk2c16zEv8cSFnz3BV/A7a
XhVRJibbZQs99pTzrwH3VzAWz4Favr1OAqnsvYD2B8X6gWL/PcjtNPtn9ucMe11LE9R9oNX0lMeV
aNa+kH8qx9JLiZbbVkM/Qfrr2rHWbwHqLr7Da5kaZ8qzvxf5NutCrijBkYdRjduaJXZPoM0A4x0h
VDwscuvWvbGtw4Lasb2K5yfw9s/FXEViQuMifipGXJ8VY0Pb6rRkrUbCm9MI82iZ9KRaV5rTBx9p
f1wp7X4S7YPHj8KqR4eHm6yG8UTNSIjBnVL+9VlGuaQlvqPP99ObWXkRbthozltfL4L0Nc488bhS
Yuvsper/nmL8jKwiWDRtVYoC61uZpCeEZxSS6lGl8Sv5PB0xUyUHXudFRJTQvQp/XRYamS7SWO9L
NuHTpfPrFsG3kzWy3mNLM3fxPla6Wcnfi/LT8kWRxXbK2+OE8lbvI31bvpE4H6x3PlIjq3x7mdzQ
ymT8GcbOQzrGnd7RLMdgBG/fgnf0rshVaiLiwEtWDKz7mCNSnpPtZVv4f52/10xkok6P0kUgOv3q
9Cse1p0euehRU57CE+vRJufy3xaj9xXHj/ci+phP8wW/oxm5v6JslK3DVuDV1jpuDyzLiNIbMipH
yCe6ZiXP5Uzev81wl7N+V6W2afDbK8490KfMShKc/oO8IxUlcvh9OtOX6l5ttNdWb2Xcvx0pmr+c
xJIFM6frPHsZn93CqtRxibWrxlCFfwIQPlrAZ+1c4ffxPOh7eJtwpuQm/+2qA/fUHoh8XuAZLXbi
upQa+ZlfT3Kr+mhm/EjmDp7NGhd1DGj0cogjeF18t+xRSx8fOq0Hve7kQYt+mMjPLQu/rB2rkrQj
+thrREnVgA+oCe+KcwIflHM51dFP3fxiu/vRDDYvi9/FqNVqcf7tGvv50nJc6cmmEZ6PEJ8tJtYb
LZcM08qkzViXKweXlfS3YBtDZhvRU+hmm/bNNoxDhD+yTrRrJqrCtI2zURW+7Z6R/DDfWAApafPM
VIV5+tnJtKJc/LXYn8nnx03v+XFR5sPUY/hT68awOkdYF+8f4F7MPWMkS6wYcj/5vkFPs0tkE3Ot
21cKiUjXRSGXYdTFHutGXK6slmqEm4sY8rmPLJspXYzQtAMYO8tKlgQTb47wdNQJWJpjix2XPWg9
QKj8WTdTBTydJKgQqnsMOz3idhrDr46BXT0Dm7oQ1dUhKG0m/dKfm+Lrpqt81umiSWpUPaXnDMl5
sZTayU6fiXUqmj77xvfd86gw4lqXo67yhrnihMn/Ncmfbf0btc6NuW6Iy0k+/tR/mpN8i+prunuX
oV6lef+wX1QdIZJwW5yNpfviZOQ/I9evCxpW8WPeAzbP7M3akwHurU7nbFkYFp2FWRYLw+vVEP6i
vz/jaqWWde0oRNMbzZ3gaoP1ohm1MVbHdhEiF0/cnO1B66vRG4im2lZDlL4RnqX6Wpk5Ug/rLUrN
B8DqZnYTQCjMf4NFvypyYkJh7RQ1OGLiRyzkF7SV5Kfv+kcve2YLFsuixLUuYdYgvWVoIp5WvX9H
6jvS3bvprOaKWx6v36guEzfWo3DDpPOURyWH4vKn+u367Hy7eIyuzrhf7r1PBj5vlY7xPjwywu+L
KmpstqE40vq/9lBdRyr8fIMO49XZSB9inUfxvrLv0Y++Bq1whbqPf+veOIAWYacoYvK2OgPXjeZd
baXl+rx7PTRZb22yh8PPcrjXRckN0cdDa4u85ngqxuW0iW6NzfuJdMTd+OPKD5szK/ZnV2NZWLY/
wnaX2f1Gq5gLfYNSTHT0/hzsbcmtOuzKtYzacogt7rA2/Ug4d6HCfD+rc+WnbX523J03r4oVxCSQ
LzHtZjW/SoxLDvjbMz9L5mPDmuEntTlnmDVCvuF3VReFw1U0LAbPXc46yhZ6RSszK/Bx9c+I//AO
M5GGWD3+TLFKJkmgvYkUrMwwE2e/spdc08+k9lRPHY48j1eijXS8UWYnfVgEJeVYs77yWW8+Y26L
cZqRr/dEeIpLr7Xu9Ja7dyv2lGutSlqf6Z4FPbtFdVe2a8XiCjZjcV9ac92ziOep/dRFH+fr0VEL
dI33pFMrdITxRpbpUm9/+Hf9fDW9xBJMSs2a4O6brRSrb8bGjcqVLT5MCsNwcF/n+FoYt9jLFGVF
rJAb15+rsgBl3+TM78fZid99XO2r+vgQNe6rxdvHxV/nhSdlhhbqF5pnsHRRKZ5yOVZyhd/ybeQd
i/KJfCa77TGkerrrI0fVMjfP+JA+KrNi8InCRkN8n7fP6cfHPerku/ZcBB3sF+N/iTc2neIuJNuB
jNVHudYoe2i3rvdmmG5p5LWqQsQB+g0fCs/BtGaOheU29Ex2okxYktX9DeB5h74Eu6U0xlp+HvHo
dPp0L9msJq8EbO68bKd2pL9Tr64SizxKP1jMGA8q2xyi/pjuTgzTzSOk8A5nvVuMmor421Wf0UlG
iMbqMKVc1ONXz+H4OHVWKfYs/wZ5R1Zdi7Bb2xNm1C3NzCbSEztOHarTVbjKEOat39XjOiruTO+0
vWlt94sotF+zSzpI9bPftX5rirW1On6Ll4vhll2xZlVZVczwSBt1r4928jzkfbN554i5xynnZy3Y
uOntw1eLd5fF1tBskE/Fzlp6O8NLbIwZ0l9q2hBDWrQoUnxpnFd0KTa2blGmfvQoU9wId5jn16SG
LnNUKrW2ddGq5YxctT2KlWaN+61awDZ6qk36CfNYLZtGdvlkuDtNYV4tuWUpmdbti362ossTDM0T
DM+dO8ZzZqdoh5gtErMHXTINQ09juUTW9fiUJ73Ftxiseebq6SoA2PRmrknmVr0r5NS76N2Juah5
0lPw7T0J352GdzsNL+YQ8xI0iX4uvjsb78KbutVmeeKZRKHeFec8xcxukZ+LdIrel3oamxvjGctz
IU47SbBWCj9RIOKbCxjbRR38RqLLj3fbjU61zn4SsB4TI1inaIma2l0OOxW5ePnBXYbwcmYI97sM
4S47B+k47LJzFiw7Z1H8h+r8lG/RgwjPG+l8iM6HSJM73PkPy7uTuSweRKody2/Ph6i/lzhV7oj8
XpxcDXVO5yOAYRGlusiiO35Vu0mh2TYx+T7vXSKWrSberONeT9T+7h+XHZ+q/Zrt4mZmt7rFJRa0
fnuK+vDsvpQNpVK8bdTad7eifueil/0G//x3K8w7F3V3eLrvWuh3MOpuC7TfiQjpJZc0hlXXX3fa
CwnBQN//xlx7fzTX3h/PtffNhnpvZy8htcvXLGrh28+D8W9t2cF5gFV8iH9HS/jsLWJomwclVrbW
txLPA4dWXrLJCNnBe18ItF2L/LWqu8z853YyZ20q0ld1y1mZK3+S/VJIsvz0I4ztEGwkyT/9R602
8ZCq+3wNePVhTMldOn0c3+Gsd9Ine74DozBGeTH1qYfkc28d/djeXud2f53+Vr6S5zovhN0jLvZo
fzsfGQviLb3UUEp9Pdt1qQiputcj0IR99M36oBVHSn7XreaeQ32vZkh1mVJEG/Uj/tBpBa9CqtPs
MmMlz/KIVszu/uq1WkvkMic1e7sYyaOlGRpnxd3dTd8spmLQM8x4Td8tVj1z6O6/NM8A6e8pW4N/
G5nbnWMvYewvihNYi3Sn4W8tug+MSDKZDQd4c+k2Psnx9tI+2m9iQXuJ7wrTWw2d1h1mdyg7Y4ye
kZtwbzDCxcaiJ/XXx/EdzGrPUp19ifudbIeT4c9a1r8v3iKoe9+XogPk5TnGC5eFJnb3YrP06G98
jEkXuTNnDD8Xny7zHBa2WlPhxl1B6UdIR415nF08nKa8mys8P8ziLuluSd+Fse+jzeZnnnQ+G/Uy
vp/lyV/hHlxbboEPOUdSUhd6D+NRYVtuk59AsYk18NZKjf3rfEj7CELcWxrT3Qfb5BmL5k5YbM4y
A+xXqu27tXG81KPmt7OeruKWrfW6mlMVLnXfnt5RulVzupK3uTTKcok3HPHnAOd90kO+J77cl9mq
vUGGb+2TZ+Amf11OacycUh7jfIbzvQgZUvc5yUmRZbq4uUndqapU8ksxbkp6/U9ZNSO7TWRJyeu4
kJXWUwWOfBuLfIL+AcYS1Vy4HPglx+tjYRZjLXgvWVUBtXpHXZbebjFStGaI2P+p0PIcW9RnIjKI
R/AX6ftFcYcj+WaEukb21+8v+fpznjUWmlrHfhurso1IlRyOced+NKvbN1qq+g2LVr2hh/P3HUg6
u8OZ2a2tji9z5QurXtXxo516wvvAHW/myxv5jAXVnY4r8+WK6JM3zQ1dfKHea2/6rlOfM06rygqw
+kZUvz5knWrqnlS/GIgfjaovWp5q9IN4iCs7ulqiNSjZnnwYXGrRYkGTsRTjR2GwZbkJg6arFtjF
meYbZ7rDtfFdcZq3iy3Fji31MfJA7jgnJ7V3AKdxcbLmAp59gfbjuceVuthSF1sK9zhjeJnNepXm
U+t5sWsi6v4qfuzriMWbM+Jnl+ktKq35PMWqPGN4tgyZZkO0JCM8uR6aa/YWNf0DV106HGZZQTwc
1g7+FRe/AWoGyROl+SGh8LbBIpNRnGJdHZMc+s533ZzXzXnN76esz073h++nXC9JpGvceA3sDedc
Q1N0eIq3IRCJJ2cGPmB+fD6ru7VM/GmOO48icUef4dJFh/3s1kYUnhAf5hR95Eu82a3jxjy5cYS6
0e3Gz3vP5Hn2mcuCPG/Bnslz1NGb4n5F27pTcfZH2Bk35kXuws8Jt7qeKLG4EttVZSzlt017GrF3
NFbgox+bFfyYY5hiNQKyVjoFmoZA3WTmb9BVE/l+wn3/Bk8Z368cHwqtzBZ8arWnw3BWaVzh6pao
d3zK3CB/n2HE4I6zPiyqKfPK5f7PKhnQ90pXZi6yI9/0WU9/Ohqr6KjDO7yyKN9bGTehq5JVqVYG
2wvi32Gec/kb70GrdWtF6qork/JtZX+jbFXPGR5iiBTrLTYfFWTatabVL/4uwZXi03FRbbUHrcZY
/7PUDF07mZu698wcEm9FlK18eyocV9kDUtn0AvenLvHc/WJWN6bc/apQ91UrbXUjYCMp9VDaU+M4
1T45e6taD5bR2+nsrdkDsdEekxfWzY5t5NY8ZkP7W4f9LF68DL57lRwg9Wv4nbXqTL0qSMfQ764R
wiLcVxz3zCOZ21V5p6O0ZaEbbDx7BfSvwfdi2OB3iLpbSoQNprIMNYvxEeo+u9HkNciODc5HuG49
w5vLJ7PbUFLg3XxGYPjJaXONttg5G/1ZJua44ILeLqTK2nC1uWnun46ZPRBiy+zPZ8bas3ftI9Z9
Ac3t9vpG7kNvEAiJtNdZ4phW3STvZ5xloLbBnKvWBjp8YNlVg7efE6rnARWCTU73WmWFuLXsZ/h+
IFW7Jf/+D1BLAQIUABQAAgAIANlu4Tg1JsY0PRUAAGgoAQAMACQAAAAAAAEAIAAAAAAAAABmdWxs
cGFnZS54bWwKACAAAAAAAAEAGACgBsCzvNvIAZDfv7O828gBgPufs7zbyAFQSwUGAAAAAAEAAQBe
AAAAZxUAAAAA

------=_NextPart_000_01E5_01C8DB88.BCAB5780--

0
cptsoft (1248)
7/1/2008 9:42:50 PM
Reply:

Similar Artilces:

conditional formatting
I would like to use conditional formatting to highlight cells. Here is the scenerio .. a cell has a date that is calculated from a formula. If that date falls within the next 7 days i would like the cell to change colors. I for the life of me can not figure out the correct formula to put into the conditional formatting box. Thanks in advance. One way: With A1 selected: CF1: Formula is =AND(A1>=TODAY(), A1-TODAY()<=7) In article <0ED02BFE-5813-464A-9DCE-E902D6C974B9@microsoft.com>, Dan <Dan@discussions.microsoft.com> wrote: > I would like to use condit...

Date conversion: SELECT goes well, WHERE fails.
Hello, So I have spent now couple of hours tearing my hair out about this problem. So, I have this set of data - table with string field in format 'DDMMYY-ABCD', where DDMMYY points to the date of the document. Sample field value would be 100610-47234. I want to filter the data by this date, so I need to convert it to date value. This is how I do it: SELECT .. CONVERT(datetime, '19' + SUBSTRING(documentCode, 5, 2) + '-' + SUBSTRING(documentCode, 3, 2) + '-' + SUBSTRING(documentCode, 1, 2), 120) documentDate SELECTing this in query analyzer ...

number changes into date-but I do not want it
when I type in the pH value of let's say 11.2 it changes into date like nov.02. I do not want them to happen. what is wrong?help!!!!!!!!!!!!!!!!!!!! odabuda@aol.com wrote: > when I type in the pH value of let's say 11.2 it changes into date like > nov.02. I do not want them to happen. what is wrong?help!!!!!!!!!!!!!!!!!!!! Right click the cell select format and make sure the cell isn't formatted as a date field. Should be number. gls858 Most unusual. Normal pattern for 11-2 but not 11.2 Try formatting the cells to General. What is the date separator set for in your W...

How do I name tabs with dates for the rest of the year?
I am looking to be able to name tabs with individual days (November 9, November 10 etc.) for the rest of the year without having to type each tab title. Is there a way to do this? I have looked online in several places but have not found an answer. Hi this would require VBA. Would this be a way for you? -- Regards Frank Kabel Frankfurt, Germany "jdhx3" <jdhx3@discussions.microsoft.com> schrieb im Newsbeitrag news:0D8A4EBD-3A9C-4DFF-800B-B6D3539DF839@microsoft.com... > I am looking to be able to name tabs with individual days (November 9, > November 10 etc.) for the...

Masking
I am using the following code, I would like the password typed to be masked is it possible? Private Sub Command15_Click() Dim stPassword As String stPassword = InputBox("Enter Your Password") If stPassword = "areaa" Then Me.Visible = True DoCmd.OpenForm "MICC-HQ_Frm", acNormal Me.Visible = True Else MsgBox "You Entered the wrong password" End If End Sub Thanks, Take a look at the input mask property. I believe there's a "Password" mask. -- Regards Jeff Boyce Microsof...

How can I separate rows to the bottom of the page with missing inf
I am still some what new to these Data Sheets and the different types of functions. Let me show by example what I am trying to do. A B C D E 1DVD MOVIE 16292 14.98 2140497 2140497 2DVD MOVIE 28264 14.98 2133826 2133826 3DVD MOVIE 56428 14.98 2114870 4DVD MOVIE 75638 14.98 2114869 5DVD MOVIE 35482 14.98 2111693 2111693 6DVD MOVIE 18792 14.98 2148557 7DVD MOVIE 27865 14.98 ...

Need help to identify if a specific date falls within a date range #2
Hi Biff, Thank you so much! The second formula works a treat. I knew it would be easy for an Excel genius! Thanks again for your fantastic help. Lee Jeffery. :) -- Lee Jeffery ------------------------------------------------------------------------ Lee Jeffery's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=10889 View this thread: http://www.excelforum.com/showthread.php?threadid=314216 You're welcome and thanks for the feedback. Biff >-----Original Message----- > >Hi Biff, > >Thank you so much! The second formula works a treat. I ...

No dates before 1900?!
A friend is organizing some data in Excel, which includes letters written in the 1800s. So there are the correspondents, notes, etc., and the dates. She told me Excel doesn't handle dates earlier than 1900! I found this hard to believe, so I tested it. Sure enough, if I put a date 1900 or later, it allows me to format the cell any way I want, calculates the day, whatever. With a date earlier than that, it accepts the date, but I can't do anything with it. Any way around this? Thanks! John John, have a look here for information on working with pre-1900 dates http://j-walk.c...

transferring Cash receipts between customers
I wanted to see if there was any other way of transfering cash receipts(overpayments) to other customers invoices with out having to transfer to payables and issue a check from payables and reapply. If you can, plese help. Thanks! Issue a debit note to one customer and a credit note to the other. Use a "swap" Gl account to handle the debits and credits and cross reference with the transaction description. HS -- www.DynExtra.com A resource for the Microsoft Dynamics Community Featuring FAQs, File Exchange and more Current member count: 40 ----------------------------------...

Convert date
Hi all ! I have a date from- start 26-11-2007 to end 30-11-2007, and now i want to convert this to 26-11-2007 (1) 27-11-2007 (1) 28-11-2007 (1) 29-11-2007 (1) 30-11-2007 (1) -- Best Regards / Venlig Hilsen Finn Kjølby Kristiansen On Thu, 6 Dec 2007 15:02:00 -0800, Finn K K <FinnKK@discussions.microsoft.com> wrote: >Hi all ! >I have a date from- start 26-11-2007 to end 30-11-2007, and now i want to >convert this to 26-11-2007 (1) > 27-11-2007 (1) > ...

Select Month, get the dates
Hi, I want to be able to select the month from the drop down list and once the month is selected, I want the first date cell to change itself to the first date of the month selected. For rest of the date cells I have just used the formula "First date cell + 1" any help will be appreciated!! Thanks a lot in advance. P.S. - Sorry for posting this in two forums. I realized later that this one is probably the right place to post it. Thanks. Assuming you select the month by giving a number 1-12, the formual is: (assuming year 2010) =DATE(2010,A2,1) Or, if the d...

Access 2002 conversion Date Expression
I recently converted a Access 2000 application to 2002 Format. I then discovered that all my default values for Date () had stopped working. I've tried clearing the defaults and reentering them, as well as going back to 2000 and reconverting. Neither helped. Each time, the system tells me that the Date expression is not recognized. Does anyone know how to fix this one? -- Barbara Your references are probably messed up. This can be caused by differences in either the location or file version of certain files between the machine where the application was developed, and where it&#...

(Beginner) XsdObjectGen and null dates
I've used XsdObjectGen (1.36) to create some C# classes, all seemed fine Deserialized some test XML into the class, again seemed to work Ok, but then I noticed that any of the DateTime properties of the class which didn't have a value in the XML were returning a value of "now" I tried the dataset class that VS2003 generates, and that is able to handle the null date-times Is there something I'm missing ?? As the subject says, I'm only a beginner on this so any help much appreciated Cheers, Steve C. Ah, found a sort of answer, the generated class has fields like...

Re: Calculate A Date Excluding Weekends And Holidays
I have a date and a series of tasks that need to be completed by a certain number of days from the intial date. The time to complete the tasks can not include weekends or holidays. Example: Initial date is 2/15/2006 I have 10 business days to complete a task All Help will be appreciated. Thank you. -- travelersway ------------------------------------------------------------------------ travelersway's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=17623 View this thread: http://www.excelforum.com/showthread.php?threadid=510028 A good starting place for info...

"Contact list full" Error message, but contact list is not full.
Hi, I am trying to add a new contact and it keeps saying my contact list is full (I have around 100 people on there). I delete people and still get the same message, I have even delete people out of my network on windows live, but still the same. I have had this problem for a couple of days now. Anyone help? Greetings Charles, This is an on-going problem over the past few days, and unsure what exactly is going on. However, you are certainly not alone. -- Jonathan Kay Microsoft MVP - Windows Live Messenger MSN Messenger/Windows Messenger MessengerGeek Blog: http://...

MFC application using properysheet and property page do not pop up when navigating between propertypages
Hi, I created a modeless propertysheet, i have added propertypages, when the application is launched the dialog appears on the screen, when i select any page and launch a browser so that the my application is hidden behind the launched browser, now wheen i click on the application in task bar tha dialog is not shown on the dialog.. can anyone help me in this regard. ...

Page Size Reverts to Letter when Set for Tabloid
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I find this same question was being asked in May of 2009 and apparently the problem still hasn't been addressed. <br><br>We have a number of excel documents that are formatted to print on tabloid paper. But when the document is saved and closed, upon reopening the file, page size reverts to letter size. I've tried it on several different machines and problem occurs with any that are using Office 2008. <br><br>Office is updated to version 12.2.4 and Mac is at OS 10.6.3 Well, for ...

dates
The table for my chart looks like: x-axis y-axis 12/01/97 4.0 01/01/98 4.1 02/01/98 4.2 ....etc. When I graph it, I wanted labels for the x-axis to be the year ("1997" instead of "01/01/97"). So on the Format Axis menu, under the Number tag, I chose Category = Custom and typed "yyyy" in the Type box. This worked great. But the year labels are at the end of each year, as in: |-------------|----- 1998 I want it to look like: |-------------|----- 1998 ....with the label in between the ticks. Trouble is, the data is by...

Recieved to date..
I am looking for a report that would tell me how many of each item i recieved to date... IE: All items of one supplier with columns to include supplier Category Item Recieved to date Sold to date Inventory on hand Cost Extended cost Sold Price Hi Kyle, Hi there, Retail Analytics from Professional Advantage will give you that report and more. Basically, anything that is captured in RMS can be reported on using Retail Analytics. We have the Up Close and Personal (UCAP) program available for RMS clients. UCAP...

Please help with a date formula.
Good morning all, I need some help with a formula related to date. In my Excel file, I have dates in Cells D1 to DL1, and each date in each cell represents Monday (e.g. 01/11/10) of the week. I also have dates in Cells A2 and B2. The dates in A2 and B2 can be any date, but the date in A2 (e.g. 01/11/10) is earlier than the date in B2 (e.g. 01/27/10). What I need help is a formula in Cells D2 to DL2. The formula in those cells will evaluate whether the date in adjacent cell (e.g. adjacent cell of D2 is D1) falls between the dates in Cells A2 and B2. If it is, the ...

Page Numbering problems
Hello - I have a spreadhseet with 12 worksheets. I want to print the Page numbers (starting @ 1) on each of the 12 using a footer and clicking the # icon. I select all 12 sheets at the same time and do this. However, Page 1 show for all of them when they are all selected. Additionally, I have tried to make a PDF of the 12 sheets and it is not allowing me to save one PDF with all 12 sheets. It is asking me to name 12 different files with 1 each. I believe the 2nd problem is based on the first. Any ideas of how to fix this? Thanks! IF - AND ONLY IF - YOU HAVE 1 PRINTED PAGE PER TABBED SHE...

Excel page numbers
I want to use Roman numerals for Excel page numbers (i.e. i, ii, iii). How do I do it? Take a look at http://exceltips.vitalnews.com/Pages/T0536_Roman_Numerals_for_Page_Numbers.html Al "hanadiv" wrote: > I want to use Roman numerals for Excel page numbers (i.e. i, ii, iii). How do > I do it? ...

date is not displaying correctly
I have a spreadsheet that I am currently having problems with the date not displaying correctly. I don't know what I did but when I first started the spreadsheet it was fine. If I type in a date such as 4/10/2004 is displays as 38087. If I want the date to display I have to type in '4/10/2004 for it to display in the cell. I need to be able to change back all of the dates that were converted to this numbering. If I go into format cells and click on date and choose the date display nothing happens as well as if I click on the general tab. I don't know what I did but, ca...

multiple date ranges
Hello, I am trying to create a query to search for various date ranges in a table. to make it easier for the user i am trying to create the query so they only need to open one query which shows pop ups for "start dates for field one" "end dates for field one" "start dates for field two" "end dated for field two" etc and if they only enter details in one set of pop ups (say they only fill in the start and end dates for field one and left two, three and four blank) it will on display results for that set of ranges only. my sql is as follows: SELEC...

Changing to date format
I have a sheet that has many rows with a date that looks like a text format. If I right click on the cell I can check it to a number and then to an mm/dd/yyyy. My question is can I change all the rows to this format is one shot. I tried to choose the whole column and do a change format but that didn't work. How would I go about changing mmddyyyy to mm/dd/yyyy? Thanks, I do not understand the first part of message, but >My question is can I change all the rows to this format is one shot. I >tried to choose the whole column and do a change format but that didn't >w...