[vicsireland] Re: excel
- From: "Gerry Ellis" <gerry.ellis@xxxxxxxxxxxxxxxxxx>
- To: <vicsireland@xxxxxxxxxxxxx>
- Date: Sat, 1 Jun 2013 19:31:35 +0100
Hi, Susan,
Now that I have a bit more time, I can give you some further info around
this.
Often you will not want to put numbers or whatever into one cell, but a
series of them. This is usually either a column (top to bottom) or a row
(side to side) of cells. You don't have to do each one individually.
Let's assume you want to change a column of cells starting at A1 and ending
at A100. Hit F5 and you are put into a box. Type a1:a100 (i.e. a1 followed
by colon followed by a100 with no spaces) and hit Enter. Then, when youhold
down Control and hit the 1 button and do all the things described in my
previous email, the changes will affect all the cells in the range you
specified.
I hope this helps.
Take care,
Gerry Ellis
If you dont know where youre going,
How will you know when you get there?
-----Original Message-----
From: vicsireland-bounce@xxxxxxxxxxxxx
[mailto:vicsireland-bounce@xxxxxxxxxxxxx] On Behalf Of Gerry Ellis
Sent: 30 May 2013 20:28
To: vicsireland@xxxxxxxxxxxxx
Subject: [vicsireland] Re: excel
Hi, Susan,
Go into the offending cell. Hold down the Control Key and hit the number 1.
This should bring up the place where you specify what type of cell you are
in. Hit the tab key and you will be in a box that says something like Date.
Use your up and down arrow keys to change this to Number. When you tab you
will be able to specify the number of decimal points and whether or not you
want a comma when the number is greater than 999. Tab till you get to OK and
hit Enter.
I hope this helps.
Take care,
Gerry Ellis
If you dont know where youre going,
How will you know when you get there?
-----Original Message-----
From: vicsireland-bounce@xxxxxxxxxxxxx
[mailto:vicsireland-bounce@xxxxxxxxxxxxx] On Behalf Of Susan Curry
Sent: 30 May 2013 19:13
To: vicsireland@xxxxxxxxxxxxx
Subject: [vicsireland] excel
hi folks,
in my work sheet in excel one of the cells won't let me put in an amount of
money for instance £30.00 it just keeps coming up saying 30-jan, this
happened to me before and some one on the list very kindly helped me out but
i have mislaid their email they sent me. so please could some one please
help me out again,
many thanks
susan
best wishes
susan
--
I am using the free version of SPAMfighter.
SPAMfighter has removed 1848 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len
Do you have a slow PC? Try a Free scan
http://www.spamfighter.com/SLOW-PCfighter?cid=sigen
===========================================================
The vicsireland mailing list
To unsubscribe at any time send a mail to:
vicsireland-request@xxxxxxxxxxxxx
with the word "unsubscribe", without the quotes in the subject of the
message.
To contact the moderator send mail to:
tim.j.culhane@xxxxxxxxx
For mor information on the Visually Impaired Computer Society visit:
http://www.vicsireland.org
====================
The vicsireland mailing list
To unsubscribe at any time send a mail to:
vicsireland-request@xxxxxxxxxxxxx
with the word "unsubscribe", without the quotes in the subject of the
message.
To contact the moderator send mail to:
tim.j.culhane@xxxxxxxxx
For mor information on the Visually Impaired Computer Society visit:
http://www.vicsireland.org
==========================================================The vicsireland
mailing list
To unsubscribe at any time send a mail to:
vicsireland-request@xxxxxxxxxxxxx
with the word "unsubscribe", without the quotes in the subject of the message.
To contact the moderator send mail to:
tim.j.culhane@xxxxxxxxx
For mor information on the Visually Impaired Computer Society visit:
http://www.vicsireland.org
Other related posts: