ReePrime
Blog DMC
Learn Excel 2010- "Formulas Won't Work": #1450

Hosted by Dailymotion. For legal issues report at the Copyright Center, report us on DMC, or use the Instant Removal tool.

Learn Excel 2010- "Formulas Won't Work": #1450

B
Bill Jelen

1 Views • Oct 18, 2011

Description

Today, in Episode #1450, Christopher and Sheila both wrote in with different problems that required the same solution. Both happened to have numbers or dates stored as text. The Alt+DEF shortcut came worked - And Bill shows us how!

Keywords & Tags

#Excel business accounting spreadsheets tutorial technology MrExcel Formula Alt #DEF Dates Text Technology Podcast Software Business software

More from User

02:34

MrExcel's Learn Excel #976 - Default Comment

Bill Jelen

03:19

Learn Excel 2010 - "Date Next to a Yes" #1474

Bill Jelen

07:51

Dueling Excel - "Rank Ties by Weight" #1473

Bill Jelen

03:39

Learn Excel 2010 – “Wrap Cells and Resize" #1472

Bill Jelen

02:08

Learn Excel 2010 - "Random with No Repeats" #1471

Bill Jelen

06:30

Learn Excel - "Copy Total to Weeks Macro": #1470

Bill Jelen

Related Videos

07:27

Excel For Beginners | Functions (spreadsheets) HD

Junior Lexus

05:04

How to Link Cells in Different Excel Spreadsheets

Alexia Angelina

02:11

Tip a Day - How To Keep A Constant In Excel And Other Spreadsheets - GeekBeat Tips & Reviews

Geek Beat TV

04:00

How This Company Brings Sophisticated Business Financial Planning to Everyday Spreadsheets

Entrepreneur

00:07

Download Economic And Business Analysis: Quantitative Methods Using Spreadsheets PDF Online

Esme Scott

00:03

READ ONLINE Excel 2016 Formulas Mr Spreadsheets Bookshelf

Emildeluxe 7c