| 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 |
| 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 | |||
Threaded Mode
