Need help on custom format codes for top picture to look like bottom picture
6.
Extend 51 Custom Format Codes Excel or Tell me what you want to do
File
Home
Insert
Page Layout
Data
Review
Calibri
11
A
= 18
Wrap Text General Merge Center % , Alignment Number
Copy Paste
Conditional Formatting * Style
Clipboard
Font
A15
fx
A
B
C
D
Custom Format Codes
10-digit phone number 6-digit number with text dollars and cents 5 negative number with text and color 4-digit year with text day followed by date
3035559876
PN-49831 207.90 -752 2017 Wed 8/9/2017 June (-80%) 75.00% 3:25:00 PM 600 hours
Extend 51 Custom Format Codes Complete
text with text
File
Home
Insert
Page Layout
Data
Review
Tell me what you want to do
10 negative % with parenthesis 111 % and text
Georgia Paste Format Painter BI Clipboard
24 A A
18
General * Merge Center 8% Con Form Number
12 hours and minutes
Font T Custom Format Codes
13 military time with text 14 Custom Formats Ready
Al
X
?
A
B
C
D
Custom Format Codes
(a) Original Data
10-digit phone number 6-digit number with text dollars and cents negative number with text and color 4-digit year with text day followed by date text with text 10 negative % with parenthesis 11 % and text 12 hours and minutes 13 military time with text 14 Custom Formats ? Ready
303.555.9876 PN-049831 207 dollars and .90 cents 752.00 loss Current Year 2017 Wednesday -8/9/2017 The month is June (80.4%) 75% complete 15 hours and 25 minutes 0600 hours
(b) Data with Custom Format codes
Figure 5-73