Oh DUH!!!! Sorry I'm really not that dumb :( I didn't read your response
very well and didn't realize you had said 'shift + ;". Sorry to bother you.

"Peo Sjoblom" wrote:

To get a colon you need to hit the shift key as well since the default
result of hitting just the semicolon/colon key is a semicolon. Sorry for the
confusion


--


Regards,


Peo Sjoblom


"Alice" wrote in message
...
Thank you! One question though: You show to use a semi colon and Bob
shows
to use a colon - what is the difference?

"Peo Sjoblom" wrote:

It's a keyboard shortcut, press ctrl + shift & ;


--


Regards,


Peo Sjoblom


"Alice" wrote in message
...
OK...now I have to show my ignorance about Excel. Where do I enter
this
code? I'm truly not familiar with this program at all....just
learning.
Thank you!

"Bob Phillips" wrote:

Alice,

Use Ctrl-: (colon)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Alice" wrote in message
...
Is there a way to keep a running account of each time the date was
updated
in
a spreadsheet. I was using the NOW function to update the date each
time
a
spreadsheet was updated but it overwrites the last date entered. I
need
each
date to remain so that EACH time the spreadsheet is updated, a new
date
is
entered. Can you help? Thanks!