Prev: Formula to display nearest following Thursday in mm/dd/yyyy format
Next: some help or direction on using excel
From: Tia on 27 May 2010 21:48
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
From: Fred Smith on 27 May 2010 22:01
You should convert your numbers to text first. Something like:
=text(a1,"0000000000000")

Regards,
Fred

"Tia" <tia.abdelkarim(a)gmail.com> wrote in message
news:680394d0-2bbd-452d-ad9e-74b526a16c37(a)t14g2000prm.googlegroups.com...
> 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

 | 
Pages: 1
Prev: Formula to display nearest following Thursday in mm/dd/yyyy format
Next: some help or direction on using excel