Prev Previous Post   Next Post Next
  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 27
Default data conversion

That did work for some except I have numbers like '01.002.50.001 for part
numbers and it did not work for those. Any other ideas?

"Joe User" wrote:

"Candida" wrote:
Please advise how I can convert a number that
comes over as '40593 from our Italian firm. How
do I take the ' off of the number.


In Excel 2003, select the cells, click on Data Text to Columns. In this
case, you can breeze through the wizard by clicking Next Next Finish.

 
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
Increase Your Business By Data Conversion, Data Format and Data EntryServices in India Data Entry India Excel Worksheet Functions 1 March 31st 08 12:51 PM
Save 20% On Data Conversion and Data Formats Services by Data EntryIndia Data Entry India Excel Discussion (Misc queries) 0 March 31st 08 12:00 PM
Daily data to weekly data conversion in Excel? Poorak Kashyap Excel Worksheet Functions 2 March 28th 08 12:50 PM
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing [email protected] Excel Discussion (Misc queries) 0 March 20th 08 12:45 PM
Daily data to weekly data conversion in Excel? dlanc Excel Worksheet Functions 1 August 9th 05 02:12 AM


All times are GMT +1. The time now is 07:37 PM.

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

About Us

"It's about Microsoft Excel"