Excel report does not show number format even after implementing number format

We noticed that the data which is in number was sometimes not coming up as number inspite of applying the number format for that textbox. To resolve this issue we used CDBL(FieldName).