THE GIVEAWAY BLOG!! Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Share and discuss all about computer software and hardware.

Log in

I forgot my password

Search
 
 

Display results as :
 

Rechercher Advanced Search

Poll
Keywords

Most Viewed Topics
WonderFox Soft Promotion!!
TGB Forum @ Rule !!
How to Download Locked or Restricted Images from Photo websites like Flickr
How do I copy music onto my Apple iPhone from iTunes?
Mother Board Information!!
Get Free PDF Experte 7 Professional
How to Watch YouTube Videos Not Available in Your Country
Mac Blu-Ray Player for Windows
How to Do a Repair Install to Fix Windows 7
Root Android 4.1 Jelly Bean on Galaxy Note 2 N7105

Latest topics
» How Can I Convert EML to PST Outlook Format
Using Data Validation In Exce To Warning User When Data Entry Error!! EmptySat Mar 02, 2019 5:50 pm by toddgross0007

» EML to PST
Using Data Validation In Exce To Warning User When Data Entry Error!! EmptySat Mar 02, 2019 5:49 pm by toddgross0007

» Restore IncrediMail Email
Using Data Validation In Exce To Warning User When Data Entry Error!! EmptyThu Feb 28, 2019 5:36 pm by toddgross0007

» How to Recover IncrediMail Folders That Disappeared
Using Data Validation In Exce To Warning User When Data Entry Error!! EmptyThu Feb 28, 2019 5:34 pm by toddgross0007

» EDB to PST Converter software
Using Data Validation In Exce To Warning User When Data Entry Error!! EmptyTue Feb 28, 2017 6:39 pm by toddgross0007

» Convert OST to PST utility
Using Data Validation In Exce To Warning User When Data Entry Error!! EmptyTue Feb 28, 2017 6:29 pm by toddgross0007

» MBOX to PST Converter
Using Data Validation In Exce To Warning User When Data Entry Error!! EmptyWed Jan 25, 2017 3:11 pm by emersonhurst

» SQL Database Recovery
Using Data Validation In Exce To Warning User When Data Entry Error!! EmptyWed Jan 25, 2017 3:09 pm by emersonhurst

»  MBOX to PST Convert software
Using Data Validation In Exce To Warning User When Data Entry Error!! EmptyFri Jan 06, 2017 3:48 pm by geetjit13


Using Data Validation In Exce To Warning User When Data Entry Error!!

THE GIVEAWAY BLOG!! Forum :: Microsoft Office Tips & Tricks

Go down

Using Data Validation In Exce To Warning User When Data Entry Error!! Empty Using Data Validation In Exce To Warning User When Data Entry Error!!

Post  THE GIVEAWAY BLOG!! Sun Jan 17, 2016 9:33 pm

With this function you can reduce the wrong data type in to the coloum.[img]

1>In Ribbon click the "Data" and choose "Data Validation"
Using Data Validation In Exce To Warning User When Data Entry Error!! 2111[/img]

2>Click the "Error Alert" to insert the data
[img]Using Data Validation In Exce To Warning User When Data Entry Error!! 2211[/img]

3>The Result
[img]Using Data Validation In Exce To Warning User When Data Entry Error!! 2311[/img]
THE GIVEAWAY BLOG!!
THE GIVEAWAY BLOG!!
Admin

Posts : 161
Join date : 2012-06-11
Age : 35
Location : Malaysia

http://thousandgiveaway.blogspot.com

Back to top Go down

Back to top

- Similar topics

THE GIVEAWAY BLOG!! Forum :: Microsoft Office Tips & Tricks

 
Permissions in this forum:
You cannot reply to topics in this forum