Formatting Cells
 

Using Access2003: I received a spreadsheet with a list of descriptions and
numbers. The numbers are formated 12345678. I need to format the numbers to
read 123-456-78. I used the custom function (under format
cells/Number/Custom) as such 000-000-00 for the column containing the
numbers. The only way the spreadsheed will desplay it correctly is if I
double-click in each field. I have 9700 records. Is there an easier way?

Thanks!

--
Smitty
Somerset, PA

Formatting Cells
 

Select an empty cell, format it with your custom format, then copy the empty
cell, select all records and do editpaste special and select add
That way you will copy the format at the same time you will add zero (empty
cells when calculated are zero in Excel) force a calculation while no value
will be added


--
Regards,

Peo Sjoblom


"Bill Smith" wrote in message
...
Using Access2003: I received a spreadsheet with a list of descriptions and
numbers. The numbers are formated 12345678. I need to format the numbers
to read 123-456-78. I used the custom function (under format
cells/Number/Custom) as such 000-000-00 for the column containing the
numbers. The only way the spreadsheed will desplay it correctly is if I
double-click in each field. I have 9700 records. Is there an easier way?

Thanks!

--
Smitty
Somerset, PA

Formatting Cells
 

It sounds like the "numbers" in Excel are actually TEXT.

Try this:

Select the range of "numbers"

From the Excel main menu:
<data<text to columns.....Click the [finish] button

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Bill Smith" wrote:

Using Access2003: I received a spreadsheet with a list of descriptions and
numbers. The numbers are formated 12345678. I need to format the numbers to
read 123-456-78. I used the custom function (under format
cells/Number/Custom) as such 000-000-00 for the column containing the
numbers. The only way the spreadsheed will desplay it correctly is if I
double-click in each field. I have 9700 records. Is there an easier way?

Thanks!

--
Smitty
Somerset, PA

Formatting Cells
 

Try highlighting the whole column and then use your formating

"Bill Smith" wrote:

Using Access2003: I received a spreadsheet with a list of descriptions and
numbers. The numbers are formated 12345678. I need to format the numbers to
read 123-456-78. I used the custom function (under format
cells/Number/Custom) as such 000-000-00 for the column containing the
numbers. The only way the spreadsheed will desplay it correctly is if I
double-click in each field. I have 9700 records. Is there an easier way?

Thanks!

--
Smitty
Somerset, PA

Formatting Cells
 

Peo Sjoblom wrote:
Select an empty cell, format it with your custom format, then copy
the empty cell, select all records and do editpaste special and
select add That way you will copy the format at the same time you will add
zero
(empty cells when calculated are zero in Excel) force a calculation
while no value will be added


That did it. Thanks Peo!

--
Smitty
Somerset, PA

Formatting Cells
 

Ron Coderre wrote:
It sounds like the "numbers" in Excel are actually TEXT.

Try this:

Select the range of "numbers"

From the Excel main menu:
<data<text to columns.....Click the [finish] button

Does that help?
***********
Regards,
Ron

XL2002, WinXP


Thanks Ron. This worked too. You guys just saved me a bunch of work!
Thanks again.
--
Smitty
Somerset, PA