COMPLEX Format Excel table extracting data from SQL

V teku Objavljeno Sep 12, 2013 Plačilo ob prevzemu
V teku Plačilo ob prevzemu

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]

Vnos podatkov Obdelava podatkov Excel SQL

ID projekta: #4921408

Več o projektu

36 predlogov Oddaljen projekt Aktiven Sep 12, 2013

36 freelancerjev ponuja v povprečju za $24 na tem delu

yourjmr

Hi! Already work is done. And I am sending some samples for your ready reference. Check PMB for more details.

$30 USD v 0 dneh
(388 ocen)
6.7
priyal1997

Dear Sir.. Please check PM. Thanks - Priyal

$25 USD v 1 dnevu
(196 ocen)
6.8
datasolutionind

Let's Start.........

$20 USD v 1 dnevu
(84 ocen)
6.0
pkcyber

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.

$25 USD v 3 dneh
(31 ocen)
5.6
vsprybhanu

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

$25 USD v 1 dnevu
(78 ocen)
5.5
MDavidCrompton

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 Več

$25 USD v 1 dnevu
(35 ocen)
5.2
elboukharimu

I can help you please check your Inbox.

$29 USD v 1 dnevu
(28 ocen)
5.3
duksmth

I am very interested in your project, please check pm for more details.

$25 USD v 3 dneh
(30 ocen)
4.7
lpetraru

I already changed your document. All the cells are formated like you wanted.

$25 USD v 3 dneh
(19 ocen)
4.4
ntlabs

Maximum within 3 hours :)

$30 USD v 0 dneh
(15 ocen)
4.2
sabeshkumar

I can make it. Please check my pm.

$15 USD v 3 dneh
(17 ocen)
3.4
InnocentSathish

I just completed this project,Check private message.

$15 USD v 1 dnevu
(8 ocen)
3.1
Ricklnd

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

$10 USD v 0 dneh
(4 ocen)
2.2
chiti12

Hi I have a great experience with both SQL and Excel so I can help you. If you would allow me.

$16 USD v 1 dnevu
(3 ocen)
1.7
mahendrasharma18

Hi I can do it on time with quality.

$35 USD v 3 dneh
(0 ocen)
0.0
luthfisuladria

Hi. I can help you and deliver immediately. Please send me more details

$20 USD v 2 dneh
(0 ocen)
0.0
vijendrayadav

i m gd in skills that the owner is required....

$20 USD v 3 dneh
(0 ocen)
0.0
YJLille

Please check your inbox

$25 USD v 0 dneh
(0 ocen)
0.0
sreekollam1605

Hi, I am interested, I will complete the job on time.

$25 USD v 3 dneh
(0 ocen)
0.0
sumit3562

Will start right now. Please check PM.

$25 USD v 1 dnevu
(0 ocen)
0.0