Today we are going to use the 0, # and ? placeholders in custom formatting in Excel. Timestamps 00:00 Intro 01:03 What the different placeholders do 02:05 0.00 format 03:33 #.## format 04:25 #.00 format 05:06 ?.?? format Resources: Learning Microsoft Excel RUclips playlist: ruclips.net/p/PLcdqmgfWC-h7JVaVViVxRiiMOMh_2Z1Kw Excel challenge: ruclips.net/p/PLcdqmgfWC-h6LfgQMq1CsyT_Hr7WLHaSD WeCanEduTech Pinterest: www.pinterest.com/wecanedutech/ WeCanEduTech Podcast: wecanedutech.podbean.com/ WeCanEduTech FB: facebook.com/WeCanEduTech
Today we are going to use the 0, # and ? placeholders in custom formatting in Excel.
Timestamps
00:00 Intro
01:03 What the different placeholders do
02:05 0.00 format
03:33 #.## format
04:25 #.00 format
05:06 ?.?? format
Resources:
Learning Microsoft Excel RUclips playlist: ruclips.net/p/PLcdqmgfWC-h7JVaVViVxRiiMOMh_2Z1Kw
Excel challenge: ruclips.net/p/PLcdqmgfWC-h6LfgQMq1CsyT_Hr7WLHaSD
WeCanEduTech Pinterest: www.pinterest.com/wecanedutech/
WeCanEduTech Podcast: wecanedutech.podbean.com/
WeCanEduTech FB: facebook.com/WeCanEduTech
I want to highlight the cells which contain only "0" and not others how to do that?
This was an excellent video. I've been using excel for decades but always ignored this portion. Thank you for making it easy
You are most welcome. Happy to hear that the video was helpful.