 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2007Green Arrow, Access to Excel, Convert en masse?
Access 2002, converting data from Access to Excel, numeric data shows up with the horrid green arrows. I can change these one by one, but is there some way to change a whole column of these entries at once? Changing them one by one is way beyond annoying. Thanks, Format all to General. Copy an empty cell. Select the range of data and Paste Special>Add>OK>Esc. Gord Dibben MS Excel MVP >Access 2002, converting data from Access to Excel, numeric data shows >up with the horrid green arrows. [quoted text clipped - 4 lines] > >Thanks, >Format all to General. > [quoted text clipped - 3 lines] > >Gord Dibben MS Excel MVP OK! So far so good, the numbers are really numbers now. Now I have the vise-versa problem - zip codes that have the little arrow. I've tried formatting as "Text" but it still keeps the green arrow. Is there a way to fix those also? Thanks Your original post mentioned "numeric data" only, not zip codes. Did you include those in the paste special>add operation? You should not have. What does the green arrow dropdown options think is the problem with the zip codes? Inconsistent formula? Number stored as text? Gord >>Format all to General. >> [quoted text clipped - 11 lines] > >Thanks >Your original post mentioned "numeric data" only, not zip codes. >Did you include those in the paste special>add operation? >You should not have. No, they came over that way. >What does the green arrow dropdown options think is the problem with the zip >codes? >Inconsistent formula? Number stored as text? "The number in this cell is formatted as text..." (Duh, that what I want :-) It only occurs on the 5 digit zip codes (00000). The nine digit (00000-0000) are fine. Hi Tools>options>Error checking>uncheck Background error checking  SignatureRegards Roger Govier > Access 2002, converting data from Access to Excel, numeric data shows > up with the horrid green arrows. [quoted text clipped - 4 lines] > > Thanks,
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.