Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 1
Default Set default column data format in Excel to text NOT general

We always have issues using excel and the excel engine in our programs
because things like inventory IDs that are entirely numeric are converted to
numbers and the leading zeros in these Ids are dropped. If this could be
defaulted to the text format instead of general then this would not happen.
I don't know what the ramifications of this would be on columns where all
the values are numeric. These columns should probably be best defulted to
numeric.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...ic.excel.setup
  #2   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 634
Default Set default column data format in Excel to text NOT general

Are you opening a csv file? If so then try changing the extension to .txt
and then specify that column as text in the import wizard.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"LeRoy Henry" <LeRoy wrote in message
...
We always have issues using excel and the excel engine in our programs
because things like inventory IDs that are entirely numeric are converted
to
numbers and the leading zeros in these Ids are dropped. If this could be
defaulted to the text format instead of general then this would not
happen.
I don't know what the ramifications of this would be on columns where all
the values are numeric. These columns should probably be best defulted to
numeric.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...ic.excel.setup


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel: How to choose data on two separate rows in the same column RicardoE Excel Worksheet Functions 2 February 24th 06 01:41 AM
I need more general XY point to point plotting than XY scatter in spazminator Charts and Charting in Excel 12 December 19th 05 06:00 PM
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 02:56 PM
Problem organizing text data into new excel page Tony Excel Worksheet Functions 3 October 21st 05 08:19 PM
Excel keeps converting text to date format John T via OfficeKB.com Excel Discussion (Misc queries) 4 September 12th 05 06:48 PM


All times are GMT +1. The time now is 01:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"