Report Export To Excel

  • Thread starter Thread starter zyus
  • Start date Start date
Z

zyus

I managed to export my report into excel format.

My problem is with my [BRNCD] field (text field which consist with leading
zero) which will lost its leading zero when converted in excel...ex 00104 to
104.

Thanks
 
If the same length of number format is required in excel, format the cells as
follows:

Custom (In the type box enter 00000)

This will display 00104 now

Hope this helps

Regards
 
Also, Excel automatically changes numbers like 001 to 1. You can change this
by going to Format, Cells, and on the first tab change the Category to Text.
This will keep the zeroes.
--
NO, I DO NOT WANT YOU TO BUILD A DATABASE FOR ME FOR A "REASONABLE FEE".


MikeJohnB said:
If the same length of number format is required in excel, format the cells as
follows:

Custom (In the type box enter 00000)

This will display 00104 now

Hope this helps

Regards
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


zyus said:
I managed to export my report into excel format.

My problem is with my [BRNCD] field (text field which consist with leading
zero) which will lost its leading zero when converted in excel...ex 00104 to
104.

Thanks
Click to expand...
Click to expand...
 
Back
Top