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
 
Ad

Advertisements

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
 
Ad

Advertisements

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top