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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing Text To Numbers ? 1
Numbers showing Up Centered in Cell ? 1
format troubles - possible cut/paste issue 8
Autosum doesn't recognize cell values after I cut and paste valuesfrom web page 5
problem with fractions to decimal 1
Format appears stuck..how to break formatting 2
Defaulting to date format 4
Formatting not protected when paste 7

Back
Top