Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conversion
Just been contacted by my son who living and working in Romania as an
accountant. Their accounting software is Romanian and cannot export to Excel as used in my son's firm. They have provided him with a file in html which via a conversion program has been copied into excel. My son says that there is about 1500 lines and he would like to auto sum one (or more) columns. The issue is how the Romanians represent there number system i.e. "one thousand pounds and 99 pence" in UK representation iwould be £1,000.99. In Romania this would (and is in the spreadsheet) be shown as £1.000,99 i.e the comma's and dots are reversed. How would one reverse this representation to enable an auto sum to be performed. Appreciate help in providing son with a resolution to his problem |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conversion | Excel Worksheet Functions | |||
PDF CONVERSION | Excel Discussion (Misc queries) | |||
ESN conversion | Excel Worksheet Functions | |||
Conversion | Excel Discussion (Misc queries) | |||
Conversion | Excel Discussion (Misc queries) |