COMPLEX Format Excel table extracting data from SQL
$10-30 USD
Paid on delivery
Hi all!
I've one specific table which I've extracted data from a SQL DB. However, all data on it is recognized by Excel as TEXT. I need it to be correctly formated.
Green cells: should be formated as NUMBERs
Red cells: should be formatted as DATE (DD/MM/YYYY)
Blue cells: should be formatted as CURRENCY (#,##)
*** I don't want the characters to be reorganized, but I need the cells to be correcetly formatted. ***
*** I also want to know how it's done, since I'll need to to it quite often ***
Find the table on my Public Dropbox folder: [login to view URL]
Project ID: #4921408
About the project
35 freelancers are bidding on average $24 for this job
Hi! Already work is done. And I am sending some samples for your ready reference. Check PMB for more details.
Hi, Expertise in advanced Excel functions. I've lot of experience of conditional formatting. I can do this nicely and accurately. Please let me know soon. Thanks, Virendra
I can give u simple application, which will take the excel file as input , put the specific columns in format you require and give back u output excel file.
I have been developing applications in both Access and Excel for 20 years with extensive use of VBA. I have developed several applications for Freelance clients, please see Feedback. I am UK based, a native English spe More
Done! I used only functions (no vba, no scripts, super simple) Is better than "formating" because the formating you can forget, but the functions you can copy&paste
Hi I have a great experience with both SQL and Excel so I can help you. If you would allow me.
