-
Package: Technical Appli...
- WST Free Trial - Professional Development
- WST Corporate Valuation Quiz/Exam
- Capital Group - 2021 Assessment - Quizzes
- Analyst Essentials
- Analyst Essentials Pro
- Merger Modeling Basics
- Overview of Financial Markets
- Accounting for Finance
- DBS MODULE 1: FUNDAMENTAL/FOUNDATION
- WST Internal Instructors
- Advanced Excel for Data Analysis (2016 Singapore)
- Fundamentals of Financial Modeling (PKA)
- Fundamentals of Valuation Modeling (PKA)
- JPM-AM 2015 Excel Exam
- JPM-IM 2015 Valuation Exam
- Strategic Alternatives: M&A and Buyout Options
- Excel for Entrepreneurs
- Wall Street Certification Bundle
- Financial Modeling Starter Kit
- WST Professional Development
- Quizzes & Exams - WST Internal
- Keys to Success
- Oppenheimer Pre-Work Package
- Package: Intensive Accounting Boot Camp
- Package 1: Basic & Fundamental Concepts
- Quiz/Exam for Package 1 - Finance 101
- Quizzes/Exams for Package 1
- Package 2: Core Fundamental Concepts
- Quizzes/Exams for Package 2
- USF - Corporate Valuation Methodologies
- Package 3: Advanced Financial Modeling
- Package 4: Valuation Modeling Topics
- Package 5: Merger Modeling Topics
- Package 6: Leveraged Buyout Modeling
- Package: Technical Applications - Excel
- Package: Private Company Valuation
- Package: Super-Complex M&A LBO Modeling
- Package: Distressed Financial Modeling
- Package: Bank Financial Modeling
- Package: Insurance Financial Modeling
- Package: Real Estate Development Modeling
- Package: REIT Financial Modeling
- Package: Buy-Side Series
- Overview of Financial Markets + Exhibits
- Verification
- Certification
- AIB Add-on
Data Manipulation
Questions/Discussions
Sort by Date ▼ / Top Rated
Register for free or log in at the top right of this page to join the discussion
shortcuts
for some reason when i try and use the shortcuts (control alt D/m/c/x) it changes my numbers into whole numbers only. for example 1508.4 becomes $1,508 and omits the .4... why is this?
Show All 1 Replies
Login to Reply
0
by Olivia C.
added 6 years ago
Format
Hi, when I do the Ctrl+shift+x formula the 0 shows up as a dash rather than as 0.0x, so I was wondering how I can change that?
Formating 0.0% and 0.0x in Data Manipulation
When I use macros to convert cells to dollar, money, or percent form in the data manipulation spreadsheet, I get the correct results for all cells except for the cells containing 0 for percent and multiples. For these two cells, when I apply control+shift+c or control+shift+x, I get the same dashed ...
Read More
WST Add-in
Hi! I have a newer Microsoft Excel and I was wondering how to download the WST add-in? I cannot seem to find where to download it onto my computer.
Cell Format
After using the macro shortcuts, I don't get the extra decimal point with a zero. I tried formatting the cells to change it, but that doesn't work. How can I fix this?
