If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
XP Office Excel importing CSV Files
Either: format the cells to show more decimals and leading zero
OR; rename the file to *.TXT and import this; more control over formatting (it seem that 0850.1000 is not a real number for you - ie no arithmetic will be done on it) so you could keep it as text. future reference, use news:msnews.microsoft.public.excel.misc for questions on Excel -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Keith" wrote in message ... I am attempting to import a CSV file and when I open the file in Excel I need to have the zeros not be removed from the entries that are made. Example: 0850.1000 is changed to 850.1 Thanks for any help. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Four KBs to address problems epidemic, ubiquitous and replete | Rick | General Discussions | 1 | August 19th, 2004 05:14 AM |
Four KBs to address problems epidemic, ubiquitous and replete | Rick | Setup, Installing & Configuration | 1 | August 19th, 2004 05:14 AM |
Office 2003 / Office XP Shortcut Bar | Marc Bressman | General Discussions | 6 | June 26th, 2004 08:42 AM |
Error #1321 MOS 2003 Setup | Chad Harris | Setup, Installing & Configuration | 1 | June 7th, 2004 12:22 AM |
Productkey problem when installing office 2003 on network | Stefan Schreurs | Setup, Installing & Configuration | 1 | June 1st, 2004 11:16 PM |