Formating text to number formats

[#1]

Hi,

I'm sure this is simple but I cannot manage to get the following data to be formatted correctly nor whether to do this in the script or in the UI itself.

Source data values

0000033320

0000000199

0000123123

Target data value

£333.20

£1.99

£1,231.23

Any ideas?

Many thanks,

Natalie

[MK_QSL · Accepted solution]

LOAD

  *,

  Money(LEFT(FieldName,LEN(FieldName)-2) &'.'& RIGHT(FieldName,2),'£#,##0.00') as FieldNameMoneyFormat Inline

[

  FieldName

  0000033320

  0000000199

  0000123123

];

[#3]

Thank you so much for your prompt response. This works perfectly!!!