Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Globally define all Excel worksheets as text
Hi all,
Excel stores numbers with 16-digit precision. We work with numbers that are larger than that, so they get truncated. The numbers come from a CSV file created by another application, so I can't define a column as text and then paste in the numbers. Is there a way to globally define Excel so as to say "treat every workbook that you open as being all text cells...don't convert anything into numbers." TIA Paul |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Globally define all Excel worksheets as text
Typical workaround is to simply rename the csv file with a .txt extension and
then use the Import wizard and define that column as text in the wizard during the import. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Paul" wrote in message ... Hi all, Excel stores numbers with 16-digit precision. We work with numbers that are larger than that, so they get truncated. The numbers come from a CSV file created by another application, so I can't define a column as text and then paste in the numbers. Is there a way to globally define Excel so as to say "treat every workbook that you open as being all text cells...don't convert anything into numbers." TIA Paul --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.572 / Virus Database: 362 - Release Date: 27/01/2004 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Globally define all Excel worksheets as text
I have recorded this in Excel 2003.
I Think it will also work in earlier versions. Sub AllCellsAsText() ' ' AllCellsAsText Macro ' Macro recorded 29-1-2004 by Wouter Magré ' ' Cells.Select Selection.NumberFormat = "@" End Sub It can changed into the next line of code. So will de complet shot NOT be selected Cells.NumberFormat = "@ -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
globally adding a value across worksheets | Excel Discussion (Misc queries) | |||
add values across 26 worksheets globally | Excel Discussion (Misc queries) | |||
Globally change print settings for several worksheets at the same | Excel Discussion (Misc queries) | |||
Define list of worksheets | Excel Worksheet Functions | |||
Define a range globally | Excel Programming |