Report Export To Excel

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
 
M

MikeJohnB

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
 
N

NAS

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...
 
Top