I am having trouble with getting the cursor to show up when I type. All I
get is the + sign.For instance I have spreadsheet premade and when I go into
the spreadsheet to add new data,there is no cursor to add info to the text
that is already in the cell. ie:
in the cell might say module and I need to add December to make it December
Module, but there is not cursor so what ever I type, it clears the entire box
instead of adding the info to it. Or if I misstype something and try and
correct it. Nothing.
I can change it in the formula bar, but I want to change on the spreadsheet.

Also, when I try to copy and paste say a tracking # in the cell, It goes
into some fourmula and I can right click on the cell, and format cells and go
to #'s and move the decimal point, and hit ok. That changes it, but it makes
me have to right click every cell. I tried highlighting the whole colum and
right click and format and change the decimal point, but it will not change.

In 2003 and earlier.

ToolsOptionsEdit. Checkmark "edit directly in cell"

To change the decimal point on all cells in a range with numbers like
10000.00 to numbers like 100.00, enter 100 in an unused cell.

Copy, select the range to change then Paste SpecialDivideOKEsc

All numbers will be divided by 100 to return 100.00

Clear the contents of the helper cell.


Gord Dibben MS Excel MVP

On Tue, 13 Jan 2009 10:42:00 -0800, austin63
wrote:

I am having trouble with getting the cursor to show up when I type. All I
get is the + sign.For instance I have spreadsheet premade and when I go into
the spreadsheet to add new data,there is no cursor to add info to the text
that is already in the cell. ie:
in the cell might say module and I need to add December to make it December
Module, but there is not cursor so what ever I type, it clears the entire box
instead of adding the info to it. Or if I misstype something and try and
correct it. Nothing.
I can change it in the formula bar, but I want to change on the spreadsheet.

Also, when I try to copy and paste say a tracking # in the cell, It goes
into some fourmula and I can right click on the cell, and format cells and go
to #'s and move the decimal point, and hit ok. That changes it, but it makes
me have to right click every cell. I tried highlighting the whole colum and
right click and format and change the decimal point, but it will not change.