copy,paste,calculate Cell value based on calculations & comparisonsother cells same row. Decimal places

[sandy666]

just for fun with Power Query

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Split = Table.SplitColumn(Table.TransformColumnTypes(Source, {{"raw", type text}}, "en-GB"), "raw", Splitter.SplitTextByDelimiter(".", QuoteStyle.Csv), {"raw.1", "raw.2"}),
    Extract = Table.TransformColumns(Split, {{"raw.2", each Text.Start(Text.From(_, "en-GB"), 2), type text}}),
    Merge = Table.CombineColumns(Table.TransformColumnTypes(Extract, {{"raw.1", type text}}, "en-GB"),{"raw.1", "raw.2"},Combiner.CombineTextByDelimiter("", QuoteStyle.None),"Result"),
    Type = Table.TransformColumnTypes(Merge,{{"Result", Int64.Type}})
in
    Type

raw	Result
1090.699	109069
147.965	14796
264.4785	26447
30.2495	3024

should be ok
thanks Alan