Unable to format data

D

DBarker

I have a file that was exported from Access and the
number columns I am unable to edit. I have tried copying
and pasting into a new workbook. I have tried copying
and pasting values and just text and have had no luck.
Any problems that anyone knows about that might help me
in this situation?

Thanks,
Debbie
 
D

Debra Dalgleish

If you can't calculate with the numbers, Excel may be treating them as
text. To convert them to numbers:

Select a blank cell
Choose Edit>Copy
Select the cells that contain the numbers
Choose Edit>Paste Special
Select Add
Click OK
To apply number formatting, choose Format>Cells
On the Number tab, select the appropriate format, then click OK.

Other methods are shown here:

http://www.contextures.com/xlDataEntry03.html
 
G

Gord Dibben

Debbie

Best guess is the the "numbers" are actually "text".

Copy an empty cell. Select your range of "numbers" and Paste
Special>Add>OK>Esc.

Gord Dibben Excel MVP
 
Top