![]() |
|
#1
|
||||
|
||||
![]() Hi achuki, Is there a reason you can't simply remove the tag for all records (eg by Find/Replace)?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#2
|
|||
|
|||
![]()
In an empty cell, type 1 (this will be the multiplication factor used below, using 1 will not change the cell values)
Right click the cell, select copy, then , after selecting te column, from the paste special menu, choose operation Multiply--> ok. Press Esc from keyboard to exit CutCopyMode. All column will be reformated to General format, which means that the numbers are alligned to the right side of cell, and text is alligned on the left side of the cell. At this moment, the numbers from that column are recognised as numbers, not text, and can be used in another calculations. Anyway, does not matter if you need to use those numbers, this will remove also the information error. |
![]() |
Tags |
export to excel |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
knownunknown | Excel | 6 | 04-24-2013 01:56 AM |
![]() |
Jamal NUMAN | Excel | 9 | 09-02-2011 02:08 AM |
![]() |
stnicholas81 | Excel | 1 | 07-25-2011 01:31 AM |
How Do I Put Text Values Into A CSV That Excel Will Leave Along? | eBob.com | Excel | 2 | 05-04-2011 07:01 AM |
Objective: Automatically export email text,attachment text to DB friendly format | SilentLee | Outlook | 0 | 11-14-2010 02:45 PM |