bank transfer error numbers display from workbook to csv

  • Thread starter Thread starter Tia
  • Start date Start date
T

Tia

Dear all,

I have a an excel file 99-2003 workbook that includes bank code and
salary details, it is required from me to save it as csv but when i do
so all the account numbers are corrupted
example 201018537554 but when i open in csv it shows 2.21037E+11
Please help the bank is rejecting my applicatio due to the unredable
numbers

and plus how can i get a number that contains 0000031456789 and keep
the zeros once it is in a number format
it will only work when i use the special format num portugese "numero
de seguranca social"
Please help
 
You should convert your numbers to text first. Something like:
=text(a1,"0000000000000")

Regards,
Fred
 
Back
Top