First point here is Amount should always be imported in a number formatted line item . That is why you are seeing some texts and characters in text formatted line item .
If u want to make out which are entered correctly , my doubt is what type of number(Amount) you would like to see .
only Whole number or decimal is also Ok for you .
You can get rid of Decimal points in format itself . While selecting number format you can opt out Decimal point to be zero .
and if u have not added any amount , the number format line item still would take 0 or blank depending upon the format you were selected (Zero Format) .
You can get to know if the numbers are blank or not is by having boolean line item and check for value "0" or Blank . and can be entered correct value from registry(if you have data) for those in a separate line item . If only finding out is OK means Boolean is enough .
and also while importing , it imports only correct formatted amount only .
Let me know any further assistance is needed on this .
Just wanted to highlight the client requirement - He is currently trying to upload the text formatted values and is expecting the the system should show an error since the format is not right. But once we are uploading the file in Anaplan the system is amending the numbers accordingly instead of throwing 0s which is becomes a problem to identify to right ones from the wrong ones. Hope I am able to articulate the problem correctly. Let me know if any further clarity is needed on this .
That's a good work around, Thanks But what about numbers like 12,345.45 ? Value(Text) cannot convert the above number which is a valid format Basically where ever there is a comma, Value function doesn't work