Unable to format data

  • Thread starter Thread starter DBarker
  • Start date Start date
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
 
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
 
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
 
Back
Top