Closed

Custom number formatting in Excel

I need to create a custom number formatting in Microsoft Excel to have negative numbers automatically be displayed in red colour.

However, I need to have comma-style formatting, with currency symbol.

The Excel file that is attached to this contest brief shows what I'd like to have.

I need to retain exactly the same formatting, but I need negative numbers to be displayed in red colour.

Also I need another "custom format type" to have the same as above, but instead of displaying a negative '-' sign, it displays the amount in brackets, along with the comma-style, currency symbol, and red text colour.

Thanks and look forward to some good feedback.

Skills: Excel

See more: custom format number, excel number custom, excel custom, excel custom number format, custom number formatting, excel custom number, excel custom number formatting, microsoft number, custom number format in excel, symbol of red, Excel Formatting, excel colour, number look, microsoft excel 2013, custom currency, excel create custom file, excel forward, forward excel, format excel good, shows excel, excel good format, good format excel, number symbol, forward number, excel custom format inr

About the Employer:
( 8 reviews ) Lija, Malta

Project ID: #5040421

69 freelancers are bidding on average €4/hour for this job

koolsidz

You work is done! :) Hello rbonnici :) I am an VB / Excel Expert. If you see my reviews by navigating to this link http://www.freelancer.com/users/feedback_1193882.html?period=entire_history&category=0 the More

€4 EUR / hour
(104 Reviews)
5.8
priyal1997

Hi Dear I'm happy to help you on this First I will do it. Then you can check and offer me the job if you are satisfied.. ;-)) Thanks Priyal

€5 EUR / hour
(67 Reviews)
5.4
deepbluetech

Hi rbonnici, Had a look at the sample file and can take on the task. Please confirm and I shall deliver both the format settings. Regards, Arul

€6 EUR / hour
(73 Reviews)
5.4
binaryromel

Hi there, I'm expert in Advance Excel, Formula, Function and Macro. I can do this. Please check my feedback as I've done several Excel project on freelancer. Please PM me. Thank you, FARZANA PINKY.

€5 EUR / hour
(51 Reviews)
5.3
bouslimi1979

Hi, already done. I used a conditional formatting for your purpose. So we can keep the same current format but the cell will be in red if the content have the signal '-'. I can send you your sample with this format. J More

€6 EUR / hour
(30 Reviews)
5.1
best4best

I can suggest you an easy option to accomplish the task. Please consider me and reply through PMB to discuss further.

€5 EUR / hour
(60 Reviews)
5.1
elMancha

Hello there. I'm an advanced Excel user and developer with great professionalism. I study electronics and computer engineering at Oporto university and I'm looking for work to fill the blanks on my schedule. I'm More

€3 EUR / hour
(24 Reviews)
4.6
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at my feedback to know more about me and my work. Waiting for more details along with posi More

€5 EUR / hour
(13 Reviews)
4.6
expertatwork

Hey rbonnici, please get this done in 2 minutes.... thank you... please reply :-)

€2 EUR / hour
(42 Reviews)
4.4
microk

Expert Here.. Award project and get solution within 30 minutes. Regards, Microk http://www.extremeexcelsolutions.weebly.com

€4 EUR / hour
(20 Reviews)
4.2
Edison1983

I can immediately help u with this. I'm a vba programmer having 6+yrs of exp. Pls check my portfolio to know my programming skills. Pls award me the project. Glad to assist you. Looking forward from u. Thanks.

€16 EUR / hour
(11 Reviews)
3.7
faialeem

Please Consider, I can definitely do that job, I already done this and waiting for your permission to submit it . Thanks

€6 EUR / hour
(10 Reviews)
3.7
SiroosJafary

Good day, CONSIDER IT IS DONE. I am expert. I teach excel. I can say there is no formula in excel that I cannot handle it. I've got lots of experiences in excel automating and conditional formatting. Here are the link More

€3 EUR / hour
(7 Reviews)
3.5
excel4engineers

Thanks for your clear instructions. I can do it now. You will be able to copy this format easily to any cell. I will show you how to copy this format in images. Also, I will send you images to tell you how to do it More

€13 EUR / hour
(9 Reviews)
3.4
amitchaps

Hi, This is Amit from India. Can work on it immediately. have expertise on excel. Lets start. Thanks, Amit

€4 EUR / hour
(1 Review)
3.3
zExcel

Done! Here is the screenshot http://wikisend.com/download/183128/1.jpg ------------------------------------------------------------

€6 EUR / hour
(4 Reviews)
2.9
dviruki

Hello, it's such a simple task, that I'm willing to do it for free. Please see my PM for your file with custom formats created.

€2 EUR / hour
(4 Reviews)
2.4
Aldo21

Here is your file formatted: https://docs.google.com/file/d/0B5LM-dF66NaodmllSlFVTV9YcE0/edit?usp=sharing

€2 EUR / hour
(5 Reviews)
2.4
haiyenle

I finished your task, if you want to see the result see the link. Only need to pay 5EUR. docs.google.com/file/d/0BxjQvyO3MbLqa3FUaGZ1UnBFeWM/edit?usp=sharing

€5 EUR / hour
(4 Reviews)
2.3
lpetraru

Hello. I have good skills and experience in Excel processing, data processing, data scraping, data entry, link-posting etc. I can do your task very easy. Please contact me for details. Best regards, Leonard

€4 EUR / hour
(4 Reviews)
2.0