View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tia[_3_] Tia[_3_] is offline
external usenet poster
 
Posts: 79
Default bank transfer error numbers display from workbook to csv

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