Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Mail Merge - Thousand separator and decimals | Excel Discussion (Misc queries) | |||
Excel 2002 : How to set thousand separator at tool bar ? | Excel Discussion (Misc queries) | |||
thousand separator | Excel Discussion (Misc queries) | |||
thousand separator conversion from dot to comma | Excel Discussion (Misc queries) | |||
thousand separator | Setting up and Configuration of Excel |