I'm sorry I have no ideea how to put a better title so here is my problem:
I have a file that create a database with invoices and clients and it fill up the invoice details but to some of the cells insted of the data it shows the formula?!!!!
Any Idea why?
in the attachment you will find the file... in the customer sheet I insert all the filds and in the invoice will apear the data for invoicing ..there is the problem.
thank you
The data in the (horrible) merged cell Invoice B to E 10 is formatted as text. the one below it as Gneral. If it's preformatted as text, that is what you will get. So copy B to E 11 up/down as far as you need.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
thank you , I try to fix it like you said but when I press the macro button the blue one with the arrow on invoice sheet it apears again the same problem.
Hi,
You might add a line of code to reset the format because the formulas will pick up the Text formatting from the source cells on the Customers sheet
Please Login or Register to view this content.
Don
Please remember to mark your thread 'Solved' when appropriate.
thank you a lot.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks