Paste number format into Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I paste numbers from an Access table into Excel XP,
Excel does not recognize to the numbers as numbers. When
I change the properties of the cell to the number format,
it still does not change the cell to the number format.

How do I change the default format to recognize number
formats?

Thanks
 
After you've pasted the data, select a blank cell and Edit/Copy it.

Then select the column(s) of numbers and Edit/Paste Special and select the Values and Add
options.
 
Back
Top