Hey all. I have ~ 3500 lines of data converted from Adobe into an Excel
worksheet. I need the formatting changed from general to accounting.
However, just highlighting and changing the 'format cells' does not seem to
work. I've also tried the old F9 tricks and they do not work either. Is
there a way to highlight all 3500 lines x 8 columns and get these changed?

I hope you get an answer on this one, might same me some time.
Right now, I copy my data to notepad, format cells and copy back to
spreadsheet.

"Pat Adams" wrote:

Hey all. I have ~ 3500 lines of data converted from Adobe into an Excel
worksheet. I need the formatting changed from general to accounting.
However, just highlighting and changing the 'format cells' does not seem to
work. I've also tried the old F9 tricks and they do not work either. Is
there a way to highlight all 3500 lines x 8 columns and get these changed?

Don - I found the answer myself - works slick. In a cell nearby your data,
enter the number 1. Right click on the cell and choose copy. Then highlight
all of your data, right click on the highlighted range and choose paste
special. On the paste special menu choose multiply under the operation
section and then click on OK. Then go back and delete your original "1"
entry.

"Don Murray" wrote:

I hope you get an answer on this one, might same me some time.
Right now, I copy my data to notepad, format cells and copy back to
spreadsheet.

"Pat Adams" wrote:

Hey all. I have ~ 3500 lines of data converted from Adobe into an Excel
worksheet. I need the formatting changed from general to accounting.
However, just highlighting and changing the 'format cells' does not seem to
work. I've also tried the old F9 tricks and they do not work either. Is
there a way to highlight all 3500 lines x 8 columns and get these changed?

If you use an empty cell and "Add" instead of multiply, you don't have to go
back and delete the "1" entry.

Just make sure you have formatted all to General before the operation.


Gord Dibben MS Excel MVP

On Tue, 15 Apr 2008 13:19:01 -0700, Pat Adams
wrote:

Don - I found the answer myself - works slick. In a cell nearby your data,
enter the number 1. Right click on the cell and choose copy. Then highlight
all of your data, right click on the highlighted range and choose paste
special. On the paste special menu choose multiply under the operation
section and then click on OK. Then go back and delete your original "1"
entry.

"Don Murray" wrote:

I hope you get an answer on this one, might same me some time.
Right now, I copy my data to notepad, format cells and copy back to
spreadsheet.

"Pat Adams" wrote:

Hey all. I have ~ 3500 lines of data converted from Adobe into an Excel
worksheet. I need the formatting changed from general to accounting.
However, just highlighting and changing the 'format cells' does not seem to
work. I've also tried the old F9 tricks and they do not work either. Is
there a way to highlight all 3500 lines x 8 columns and get these changed?

Gord Dibben <gorddibbATshawDOTca wrote...
If you use an empty cell and "Add" instead of multiply, you don't
have to go back and delete the "1" entry.
....

Or just select the column range containing the text-numbers and run
the menu command Data Text to Columns, and immediately click on the
Finish button in the Convert Text to Columns Wizard.

I'm not sure where this menu option is, is it possible it is not part of
default menus.
I know there are some options I can't access or install due to security
issues with the IdioT department.

"Harlan Grove" wrote:

Gord Dibben <gorddibbATshawDOTca wrote...
If you use an empty cell and "Add" instead of multiply, you don't
have to go back and delete the "1" entry.
....

Or just select the column range containing the text-numbers and run
the menu command Data Text to Columns, and immediately click on the
Finish button in the Convert Text to Columns Wizard.

Are you saying that you don't have a "Data" menu, or that you do have a
"Data" menu, but no "Text to Columns" on that menu? Which version of Excel
are you using?
--
David Biddulph

"Don Murray" wrote in message
...
I'm not sure where this menu option is, is it possible it is not part of
default menus.
I know there are some options I can't access or install due to security
issues with the IdioT department.

"Harlan Grove" wrote:

Gord Dibben <gorddibbATshawDOTca wrote...
If you use an empty cell and "Add" instead of multiply, you don't
have to go back and delete the "1" entry.
....

Or just select the column range containing the text-numbers and run
the menu command Data Text to Columns, and immediately click on the
Finish button in the Convert Text to Columns Wizard.

I have a data menu but no text to columns option

"David Biddulph" wrote:

Are you saying that you don't have a "Data" menu, or that you do have a
"Data" menu, but no "Text to Columns" on that menu? Which version of Excel
are you using?
--
David Biddulph

"Don Murray" wrote in message
...
I'm not sure where this menu option is, is it possible it is not part of
default menus.
I know there are some options I can't access or install due to security
issues with the IdioT department.

"Harlan Grove" wrote:

Gord Dibben <gorddibbATshawDOTca wrote...
If you use an empty cell and "Add" instead of multiply, you don't
have to go back and delete the "1" entry.
....

Or just select the column range containing the text-numbers and run
the menu command Data Text to Columns, and immediately click on the
Finish button in the Convert Text to Columns Wizard.

Sorry, 2003

"David Biddulph" wrote:

Are you saying that you don't have a "Data" menu, or that you do have a
"Data" menu, but no "Text to Columns" on that menu? Which version of Excel
are you using?
--
David Biddulph

"Don Murray" wrote in message
...
I'm not sure where this menu option is, is it possible it is not part of
default menus.
I know there are some options I can't access or install due to security
issues with the IdioT department.

"Harlan Grove" wrote:

Gord Dibben <gorddibbATshawDOTca wrote...
If you use an empty cell and "Add" instead of multiply, you don't
have to go back and delete the "1" entry.
....

Or just select the column range containing the text-numbers and run
the menu command Data Text to Columns, and immediately click on the
Finish button in the Convert Text to Columns Wizard.

Are you sure that you're looking at the full menu? Is there a double
down-arrow at the foot of the menu? [Or otherwise Tools/ Customise/ Options
....]
--
David Biddulph

"Don Murray" wrote in message
...
I have a data menu but no text to columns option

"David Biddulph" wrote:

Are you saying that you don't have a "Data" menu, or that you do have a
"Data" menu, but no "Text to Columns" on that menu? Which version of
Excel
are you using?
--
David Biddulph

"Don Murray" wrote in message
...
I'm not sure where this menu option is, is it possible it is not part
of
default menus.
I know there are some options I can't access or install due to security
issues with the IdioT department.

"Harlan Grove" wrote:

Gord Dibben <gorddibbATshawDOTca wrote...
If you use an empty cell and "Add" instead of multiply, you don't
have to go back and delete the "1" entry.
....

Or just select the column range containing the text-numbers and run
the menu command Data Text to Columns, and immediately click on the
Finish button in the Convert Text to Columns Wizard.