LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Hungarian excel problem with thousand separator

Hello,

dear friends I have a problem with hungarian excel ... I would need to
import a text file with numbers, here it is (copy/paste from Notepad):

Part ID Description WH UM Type WH Location MyData MyValue
TEST1 test part first test part second 100 FG
4 C5D2 190,000 72,627 13 799,22
TEST2 RED ADHESIVE LABELS "4 Nm max" (for rope 100 FG 4 C5D2 250,000
91,160 22 790,04
TEST3 BL S4Z slow and S3R/L C-MOD SMALL cont p 100 NR 4 C5D0 1 400,000
760,402 1 064 563,49

What happens is that when I import it through Excel the number 1
400,000 becomes text even if all my setups are in hungarian and the
separator of thousands is a space. Guess that space is read by Excel
as not the correct space...

Could you please help me?

Thank you,
Ivan Pololi
Italy
 
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
Mail Merge - Thousand separator and decimals cocomin Excel Discussion (Misc queries) 1 October 29th 08 12:51 PM
Excel 2002 : How to set thousand separator at tool bar ? Mr. Low Excel Discussion (Misc queries) 2 April 10th 08 04:57 PM
thousand separator Antonio Excel Discussion (Misc queries) 1 April 4th 08 03:07 AM
thousand separator conversion from dot to comma Spike Excel Discussion (Misc queries) 10 January 31st 06 09:07 PM
thousand separator R Kapoor Setting up and Configuration of Excel 5 January 5th 06 10:32 AM


All times are GMT +1. The time now is 02:41 AM.

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"