Excel vba convert number to string with leading zeros jobs

Hogarth is the Global Content Experience Company. Part of WPP, Hogarth partners with one in every two of the world’s top 100 brands including Coca-Cola, Ford, Rolex, Nestlé, Mondelez and Dyson. With a breadth of experience across an extensive range of sectors, Hogarth offers the unrivaled ability to deliver relevant, engaging, and measurable content across all channels and media - both established and emerging. The number of channels at our fingertips; the need for speed; and the drive for mass personalisation, all mean that brands need different solutions. Our global team of over 6,000 craft and technology experts brings together creative, production and innovation to help clients navigate this exciting and ever-changing world of today&r...

Hello talented artist. The search has begun for an illustrator to create 14 single-page illustrations and a double-page spread for a kid's book titled 'How Jimmy Page Led Zeppelin'. The work would start June/July 2024, although looking to source an illustrator and get costing for the project now. Written in rhyming verse it follows a young Jimmy Page as he finds and learns the guitar, joins his first band, Art School, Session Work, The Yardbirds, and finally onto forming and leading one of the most successful bands in history - Led Zeppelin. The book will be illustrated for kids aged 5 to 10 with an attention to detail that parents will love. Guitars, Amps, Drums, Costumes, Albums, Stadiums and more. The ideal illustrator would...

I have a set of PDF documents that I need to convert into Microsoft Word for the purpose of creating a digital archive. Key Requirements: - Copy typing from PDF to Microsoft Word - Include all images and charts from the original PDF I need someone who is meticulous and proficient with Microsoft Word to ensure that the final document retains all the necessary elements and details. The ideal candidate for this project should have experience with data entry and be detail-oriented.

I need an experienced social media video editor and content creator to produce short videos for a social media advertisement. The advertisement is for an upcoming Alumni Reunion/Networking event. The videos should be less than 1 minute in length, three different videos. You can use any music that you see fit but you need to have a good eye for visuals and a knack for storytelling. Key Responsibilities: - Creating engaging, 3 short videos for Facebook, TikTok, and YouTube - Ensuring the videos are less than 1 minute in length - Using royalty-free music effectively - Showcasing strong editing and storytelling skills -The videos must relay these key information 1. Name of the event is 'Poly Networking Event' 2. The event will be held on July 20, 2024. ...

...organized and saved into a customized Excel template. Additionally, the system should be designed to assign different user IDs with varying levels of access control. Key Requirements: - Develop an AI portal with the capability to extract table data from PDFs. - Organize and save the extracted data in Excel using customized templates based on the source PDF. - Implement a user management system that assigns different access controls to various user IDs. Ideal Skills and Experience: - Proficient in AI development and data extraction techniques. - Expertise in Excel automation and customization. - Strong background in user management and access control systems. - Previous experience with similar projects is a plus. The succ...

...seeking a skilled social media marketer to undertake a comprehensive campaign across Facebook, Instagram, and Twitter. My primary target audience is teenagers, young adults, adults with children. Do prefer someone in there USA. The main goals of this campaign are to: - Increase brand awareness: I want to enhance my brand's visibility and recognition among my target demographic. - Drive website traffic: The campaign should lead to a noticeable increase in the number of visitors to my website. - Generate leads: Ultimately, the aim is to convert the increased traffic into leads for my business. This project requires a professional with proven experience in social media marketing, particularly with these p...

I have a few guitar tabs that I'd like converted into the Rocksmith format. - The tabs can be a mix of genres. - I need these tabs to be converted to Rocksmith format, so that they can be easily playable within the Rocksmith software. - The guitar tabs may not be in standard tuning, so a knowledge of different tunings and how to adapt them for Rocksmith is preferred. Ideal skills and experience for this project include: - Proficiency in guitar. - Experience with Rocksmith and how to convert tabs to its format. - Knowledge of different guitar tunings and how they can be adapted for Rocksmith.

...designer to create a compelling banner for my website. The aim of the project is to enhance the branding of the site and attract more visitors. Your responsibilities would include: - Crafting a banner with unique, photographic imagery that ties cohesively into the current aesthetic of the site - Following general direction, but utilizing your own creativity and ideas - Ensuring that the banner adds to the overall appeal of the website while maintaining brand continuity and tone. - The banner needs to be 1280px x 320px - I just want to convert this poster that is attached into a banner, nothing different Ideal candidates should have: - Proven graphic design skills with a strong portfolio - Experience in creating branded banners...

...title of the graph to communicated what the graph is communicating. Add options—color, trendlines, legend, other? Calculate the mean, median, mode, and standard deviation of the adjusted daily closing stock price. Put answers of calculations in table format. Write several sentences explaining the process by which you calculated these statistics. Calculate the mean, median, mode, and standard deviation of the stock volume. Put in table format for easy review. Write a sentence explaining the process by which you calculated these statistics. Ideal freelancers for this project would be those experienced in statistical analysis and data visualization. Skills in using tools like Excel. If this sounds like your kind of project, get in touch and showcase your skills. The inf...

I need someone to help with offline data entry. The task involves entering less than 1000 entries into an Excel spreadsheet. Accuracy is key as the data will be used for business analysis. Ideal Skills and Experience: - Proficiency in offline data entry - Advanced Excel skills - Ability to maintain high level of accuracy - Previous experience with similar tasks is a plus

I'm looking for a skilled designer who can take my current Facebook banner and reformat it to fit YouTube's specifications. The task involves resizing and realigning the current design, ensuring it's a perfect fit for YouTube. While the original design should be preserved as much as possible, I'm open to minor modifications if needed for better visibility on YouTube. Ideal skills and experience for this job include: - Proficiency in graphic design tools such as Photoshop or Illustrator - Previous experience with social media banners and resizing - Understanding of YouTube's specific banner requirements - Ability to balance preserving the original design while making minor modifications for better visibility on YouTube

We need an experienced 3d game artist to work alongside us. You will be working alongside 1 very experienced unity game developer who owns and is leading the project. If you want to apply please: 1) Send us a 1 minute video of you introducing yourself in english 2) Send us a link to your game art portfolio 3) If you do not follow these steps you will not be considered for this job Hours: anywhere from 10-40 hours a week. Start date probably 1 week to 1 month from now. We will task you with numerous tasks for a week and you will need to scale your hours to complete those tasks based on the week. We will continue conversation here before moving elsewhere.

I'm looking for a professional who can turn a Pine Script Indicator into a Trend Following Strategy on TradingView. The ind...Following Strategy on TradingView. The indicator is written in Pine Script, and the end product should offer clear entry and exit signals based on the indicator's moving averages. Key Deliverables: - Convert the existing Pine Script Indicator to a comprehensive Trend Following Strategy. - The strategy should utilize moving averages as the primary factor for determining entry and exit points. Ideal Skills & Experience: - Proficiency in Pine Script - Strong background in trading strategies, specifically trend following - Experience building and implementing trading strategies on TradingView - Familiarity with moving averages and th...

...proficient translator to convert a technical document from English to Spanish. Key Requirements: - Understanding of technical language: The document contains technical jargon, so the translator must have experience in this field to accurately translate it into Spanish. - Attention to detail: It's critical that the translated document is error-free and retains the original meaning and terminology. - Fluency in English and Spanish: The translator must be fluent in both languages to ensure a high-quality translation. Ideal skills and experience: - Professional translator with a background in technical translations is preferred. - Experience in translating documents from English to Spanish. - Familiarity with the subject...

...professional and creative PowerPoint expert who can convert my content into an engaging sales/marketing presentation focusing on Market Analysis. - The content is all set, requiring your designing services only. - The presentation will highlight market parameters including Competition, Consumer Behavior, and Market Trends. - It's crucial that you convey the information in a captivating and understandable manner, aiming to pitch our sales strategies effectively. Ideal Skills: - Proven experience in designing PowerPoint presentations, preferably for the sales/marketing sector. - Proficiency in utilizing advanced PowerPoint tools and graphics. - Strong understanding of effective presentation techniques for sales/marketing. - Experience with successfully commu...

Convert my website, , into a PWA - a Progressive Web Application. 1. I want to convert my existing website on PWA 2. Can able to link on footer with any icon or picture, so any one click on that to install in mobile or desktop Example of PWA Wesbite CMS Cs-cart

I'm looking for someone with strong data gathering skills who can create a comprehensive Excel spreadsheet. The spreadsheet must contain a list of all Australian suburbs along with their corresponding Local Government Areas (LGA). The essential points to be kept in mind are: • The list should be sorted by council areas for easy navigation. • Only the name of the suburbs and their corresponding council areas are required. No additional components such as population or region data are necessary. This project might require advanced web searching capabilities and attention to detail to ensure accuracy of the compiled list. Experience in data extraction is highly desirable.

I'm looking for a skilled translator to convert an English document of 200+ words into Arabic. Key Requirements: - Fluency in both English and Arabic - Proven track record of delivering high-quality translations - Cultural understanding to ensure the translated content resonates with Arabic-speaking audiences Additionally, it would be beneficial if you: - Possess subject matter expertise in the content's industry - Are able to meet tight deadlines without compromising on quality Looking forward to seeing your proposal.

As an HR professional, I am looking to generate leads that will convert into sales or engagement for my company. Key Requirements: - I'm looking for a freelancer with tangible experience in generating leads in the HR industry. - Your application should showcase your past successes in this field. The primary goal is to increase sales and leads through this initiative, so I need someone with a proven track record of achieving this within the HR sector.

...who can create a database in MS Excel for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List). 2- A list of all Contracts. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. There should be a Dashboard (Main Page) with link to the pages (Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages) on the top, and below the page list there should be the statistical data of the database. For Add New Invoice page, I should be able to add an invoice details, and if it's related to a contract or purchase o...

I am seeking a skilled Swift iOS developer who can create an innovative, user-friendly application for man...create an innovative, user-friendly application for managing driving routes via GIS .shp files. Key Features: 1. Import GIS .shp files and convert them into driving routes. 2. Incorporate a web portal feature to assign and track drivers. 3. Real-time updates on the progress of each route. The ideal freelancer for this project should have experience with Swift, iOS development, .shp file manipulation, and incorporating real-time updates into an app. The app also needs a mobile version for drivers to access their routes; therefore, experience with mobile app development is also desired. More specifications will be provided upon selection. Look...

I'm in need of someone skilled in Microsoft Excel for a couple of tasks. - **Formatting:** Firstly, I require assistance in formatting the spreadsheet. This will include ensuring that the data is clear and easy to read. I would like the spreadsheet to look professional. - **Formula checking:** While the formulas used are not too complex, I still want them to be checked thoroughly for accuracy and consistency. This will mainly involve basic arithmetic operations. I'd appreciate it if you have a background in financial analysis. It would be helpful to have a good eye for detail as well.

We are currently in the market for an experienced designer to join us in creating leading-edge workout clothing designed specifically for men. With performance as the main objective, we aim to provide gear which not only helps enhance workout results but also promotes long-lasting use. Ideal Candidate Skills: - Experience in designing men's activewear or similar clothing. - Strong understanding of materials and fabrics suitable for high performing athletic clothing. - Proficiency in clothing design software. Project Duties: - Design a range of workout clothing for men & active wear - Ensure designs specifically enhance workout performance. - Choose appropriate, durable, and high-quality materials. We're excited to see your designs th...

The target is to write a Java, console program (public static void main) that will generate a docx Word file. Program needs to use docx4j library () Programm needs to generate many parts: Heading1, Heading2, Heading3, every with some content (lorem ipsum) Make a table of contents (showing on which page is a given Heading1, Heading2, Heading3 - not hard coded, but detected) Heading1 --Heading2 ----Heading3 ----Heading3 --Heading2 ----Heading3 ----Heading3 Heading1 --Heading2 ----Heading3 ----Heading3 --Heading2 ----Heading3 ----Heading3 In the text put links to a concrete Headings, eg. "read in Heading2 - abc (page 4)" - it should be link to this section and "(page 4)" should Make a footer showing the number...

I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample

I need a skilled individual to convert my current Laravel website to WordPress. The main reason for this transition is to ensure that I have a user-friendly, easy-to-manage website. Currenlty, the website is built with Laravel, but I would like it to be converted to WordPress to make it easier for me to manage and update the content. Ideal skills and experience: - Proficient in Laravel and WordPress - Strong understanding of website architecture and conversion process - Ability to ensure a seamless transition - Good communication skills and ability to explain technical concepts to non-technical individuals.

I require an experienced and proficient VBA developer to create a code that automates data entry tasks in Microsoft Excel. The main objective is to significantly increase productivity and ensure accuracy by automating repetitive data entry procedures. Ideal skills would include: - Vast knowledge of VBA and Excel - Prior experience in developing automation scripts - Exceptional attention to detail - Ability to work within strict deadlines

I'm in need of a seasoned Excel expert who's proficient at conducting optimization analysis to solve a real-world problem. Key Requirements: - Profound understanding of optimization analysis - Ability to work efficiently and quickly - Experience with diverse Excel functions Please note that the specific goal of the optimization analysis requires maximizing profits, minimizing costs, or optimizing resource allocation. Your expertise in this area will be crucial to our success.

We are developing a project that we believe needs guidance and advice from an experienced scientist with specialized knowledge in the field of neuroinflammation. Your Expertise: - Microglial activation - Cytokine signaling Our Project: - In surgical patients, we are studying questions that relate to post-operative problems. In this group, you will give consultation on the serological evaluations that relate to neuroinflammation. Research Goal: - We aim to uncover a new understanding about the brain, hopefully leading to unexplored conversations within our field. Ideal candidates should have proven and published experience in neuroinflammation research, particularly involving microglial activation and cytokine signaling. (Note that the actua...

I need an expert to convert tables from a PDF file into an Excel spreadsheet. The job involves transferring text and numbers from a multi-page PDF table to an Excel document. I have attached the PDF. The analysis should start from page 7. Here's what the project entails: - Converting data from a PDF table that includes both text and numbers - Handling tables that span across multiple pages in the PDF - Transferring the data to Excel without any need for specific formatting or layout changes - Provide the developed script used to obtain the records from the tables. As a freelancer, you should have: - Proficiency in PDF to Excel data conversion - Ability to work with complex table structures - Attentio...

Seeking experienced funding professionals to secure foundational support for a non-profit organization focused on domestic violence advocacy. We intend to raise awareness through comprehensive advocacy campaigns delivered to the general public, policymakers, and survivors of domestic violence. Ideal candidates should have: - A proven track record in securing funding for non-profit organizations, preferably within the advocacy sector. - Knowledge and experience in domestic violence issues. - Strong networking skills to reach a diverse audience comprising the general public, policy makers, and survivors. - Familiarity in launching and leading advocacy campaigns. This project requires an innovative approach to not only generate funding but also rai...

**Contest: Excel Specialist Wanted for Comprehensive Property Portfolio Management Tool!** Are you an Excel virtuoso with a passion for crafting intricate and comprehensive spreadsheets? We're embarking on a quest to develop the of a cutting-edge Property Portfolio & Financial position Management Tool for our discerning clients. If you possess the expertise to meticulously organize data, create advanced formulas, and design visually captivating presentations, this contest is tailored for you! Join us in revolutionizing property portfolio management with a document that sets the standard for clarity, accuracy, and usability. I would like to be able to edit if required in the future therefore 2 copies will be required. 1 being...

I have an algorithm that I need to be translated into pseudocode. Requirements and Constraints: - The original algorithm is written in English, so you must be able to interpret this language and convert it effectively. - You should consider resource limitations, as the translation will need to be efficient. - Additionally, you need to consider time complexity constraints when converting the algorithm. Ideal Skills: - Proficiency in understanding and writing pseudocode. - Extensive knowledge in algorithm design and analysis. - Ability to optimize algorithms for resource efficiency. - Experience working with time complexity constraints.

...who can assist me in creating two unique games - an aviator game and a color picker game to be integrated on my website. - Responsibilities: - Develop an engaging aviator game. - Create an intuitive color picker game. - Assist with integrating the developed games on my website. I do have some ideas for these games but am also open to any creative input from you. - Skillset Required: - Strong knowledge of game development. - Proficient with web-based game creation. - Dexterity in seamless web integration. - Ability to convert ideas into interactive gameplay. Experience in similar game development projects would be advantageous. Your expertise in crafting web games that align with my vision could create a long-te...

Looking for a structural engineer to evaluate and advise repair on a load-bearing wall in a residential structure urgently. It seems that there isn't one installed, leading to potential structural issues. Details: - Type of building: Residential. - Material: Currently lacking a structural wall, the choice of material will be advised by the professional based on requirements. Requirements: - Swift start time, the job needs to be completed ASAP. - Experience in residential building strengthening and rehabilitation. - Skilled in determining and installing the right kind of load-bearing walls. Do get in touch if you can do a quick yet thorough job, and can start right away.

I'm experiencing multiple performance issues with my WordPress site hosted on a Virtual Private Server (VPS), which has plenty of resources (8 vCPU / 12GB of RAM, SSD). The problems include: - Consistently slow loading times on the front end - High server CPU usage, which I suspect is leading to the slow loading times - Database connection errors - Posts in the backend are taking a considerable amount of time to load I haven't made any recent changes to the site, such as installing new plugins or updating the theme, which could have caused these issues. I need a skilled professional who can dig into these issues and improve the overall performance of my site. Ideal skills and experience for this job include: - Extensive experience with...

I'm looking for a proficient mechanical engineer to design a geothermal snow and ice melt system in my driveway. There is no existing heating system to integrate it with. The driveway is quite extensive, at a little over 3300 square feet. Ideal skills and experience for the job: - Understanding of depths and number of wells needed for the system. - The heat exchange system and heat pump required to handle this square footage - Prior experience setting up geothermal systems - Knowledge or experience in dealing with large-scale driveway installations - Ability to work without integrating existing heating systems.

I am looking for a Jinja2 frontend developer to convert our simple Figma design files into Jinja2 files. This work will prepare the files for our in-house frontend developer to implement into our site. Key Responsibilities: - Translate Figma design files into Jinja2 web templates. - Ensure the templates are well-structured, clean and easy to implement. - Implement basic functionality like navigation bars, forms, and image sliders. Ideal Skills: - Proficient in Jinja2 templating language. - Strong experience in frontend development. - Familiarity with implementing designs from Figma. - Ability to work collaboratively with our in-house frontend developer. This project is straightforward as the design is simple with just a few pages....

I need a software expert to develop a program that scrapes text content off of multiple websites and then cross-references this data against another site. Key Requirements: - The software should effectively pull out text content from all provided sites. - The text content should be in a plain text format, ready for easy analysis and interpretation, preferably in an excel spreadsheet or comma delimited list. - The cross-referencing component is crucial, as the software will need to compare the data scraped with that of another website. Qualifications: - Background in Data Scraping and Software Development. - Previous experience with cross-referencing data. - Proficiency in handling different data formats. In essence, I'm looking for someone who c...

...proficient email marketer to help me increase my sales conversions through email campaigns aimed at potential customers. Key Responsibilities: - Develop, execute, and monitor email marketing strategies to increase sales. - Create engaging sales emails that will entice potential customers. - Regularly analyze the performance of the email campaigns and adjust as necessary. Ideal Skills and Experience: - Extensive experience in email marketing, particularly in the area of sales conversion. - Proven track record of successfully increasing sales through email campaigns. - Strong understanding of potential customer behavior and how to target them effectively. - Excellent copywriting skills for creating compelling sales emails. - Proficiency in email marketing tools and...

I am looking for someone skilled in Microsoft Excel and Power Automate. This task involves creating an automation system that sends emails to our internal team members based on given triggers. The automation should trigger when: - An event's start date is approaching - An event's deadline is nearing The email content should serve as a reminder of the approaching start dates. It's pivotal that the chosen freelancer can work with accurate detail to ensure that no deadlines are missed. A deep understanding of Excel, or similar spreadsheet software, automation, and email systems is required for this task. Experience working with scheduling and deadline tracking will be an advantage.

I have a 120MB JSON file with nested objects, and I am in need of a skilled professional who can convert this data into a CSV format. Specifically, I require the following: - The nested JSON objects should be flattened into single columns in the CSV. - The column headers in the CSV should match the keys in the JSON file. The ideal candidate for this job should have: - Proficiency in handling JSON and CSV data structures. - Experience in working with nested JSON objects and flattening them. - Ability to accurately map JSON keys to CSV column headers. If you've successfully converted complex JSON files into CSVs before and you're confident in your ability to deliver clean, well-structured data, I'd love to hear from you.

I'm in need of a WordPress developer to convert html files to a Wordpress theme for a doctors website. Key Features: - **Contact Form**: A basic contact form to collect user information. Images and text will be provided. Two main layout files will be provided. One for the home page and the other for content. Ideal Skills & Experience: - Proven experience in WordPress development is a must. - Familiarity with creating contact forms.

...require an expert in Excel to help me with a statistical analysis of my sales data. The key tasks for this project are: - Conducting statistical analysis: I need you to run a detailed statistical analysis on my sales data. This will involve using advanced Excel functions to analyze variables such as sales trends, forecasts, and correlations. The ideal candidate for this project should have: - Proficiency in Excel: The chosen freelancer should have a deep understanding of Excel and be skilled in using advanced functions. - Statistical Analysis Expertise: Experience in statistical analysis is crucial, as you will be required to interpret the data and provide insights. - Attention to Detail: The work involves handlin...

...professional who can convert my PDF document to an editable Word document, ensuring that the layout, font styles, tables, images, and page numbering are all maintained. Key Requirements: - Preserving font styles and formatting: It's important that the text in the Word document appears exactly as it does in the PDF. - Keeping tables and images intact: The tables and images should be accurately reproduced and remain in their original positions. - Maintaining page numbering and headers/footers: The Word document should mirror the PDF in terms of its pagination and any header or footer content. Evaluation: - Accuracy of text conversion: I will compare the text of the original PDF with the Word document to ensure that there are no errors or omissions. - La...

I am looking for a skilled programmer who can adjust my self-developed trading strategy on TradingView into a system that can place limit orders on the trading platform, currently its market orders. Key Requirements: - Take the signals generated by my proprietary trading strategy and convert them into actionable limit orders. I need this project completed as soon as possible. This needs to happen so as to sent webhooks to ninjaview which sends them to ninjatrader

We are currently experiencing significant performance issues with our Oracle database under heavy loads, leading to frequent hangs and disruptions in our operations. To address this critical situation, we are seeking the expertise of an experienced Oracle Advanced DBA freelancer. We require a professional with the following qualifications and skills: - Extensive experience in Oracle Database Administration, particularly in high-load environments - Proficiency in performance tuning, query optimization, and troubleshooting - Familiarity with Oracle Enterprise Manager and other monitoring tools like aws performance insights The main responsibilities will include: - Diagnosing and resolving performance issues - Implementing best practices for dat...

I need to improve the existing features of an Excel macro, focusing on enhancing the user interface and experience. Key points: - The primary goal is to make the macro more user-friendly, interactive, and provide better feedback to users. Ideal skills: - Advanced Excel Skills - VBA and Macro Programming - Strong UI/UX design capabilities - User Feedback Integration Please bid if you have experience in enhancing Excel macros in a user-friendly manner and can improve the UI/UX by adding interactivity and feedback. I have a macro working fine. We need 3 improvements: 1- Label photos as A, B and C / 1, 2 and 3 then macro relabel photos per photo matrix 2- Instead to use “SN” in the folder name I want to use &ldquo...

...have four logos which I need to be converted into high-resolution files suitable for printing on large flags. The logos are currently available in JPEG format. I don't need any redesigning, just a simple resizing to ensure that they scale perfectly for large flags. The flags will be used both indoors and outdoors, so the resolution needs to be top-notch. Key Requirements: - Convert four JPEG logos into high-resolution files - Ensure the logos are suitable for large flag printing - Keep the original design of the logos intact - The logos should be scalable without any loss of quality Change the color of the black flag to a nice green. Ideal Skills and Experience: - Proficient in graphic design and image editing - Experience with logo resiz...

...automate various tasks in Excel. This includes, but is not limited to, data entry, formulas, and calculations. Key responsibilities: - Automating data entry processes within Excel - Implementing advanced formulas and calculations to streamline calculations - Generating reports and carrying out data analysis using Excel - Ensuring the accuracy and integrity of automated processes Ideal skills and experience: - Proven experience in automating tasks in Excel - Advanced knowledge of Excel functions and formulas - Ability to understand complex data sets and create accurate reports In your application, I'd like to see: - Examples of similar projects you've worked on - Details of your experience with Excel...