Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data Validation

Status
Not open for further replies.
simoncpage

simoncpage

Programmer
Apr 4, 2002
256
GB
Is there anyway of using excel built in data validation to validate to a format (rather than just a decimal)...such as #,##0.00? Or would this need to be coded?!

Thanks

 
Sort by date Sort by votes
Simon,
Are you talking about custome Fromatting? Go to your formatting screen and scroll to the bottom for "Custom", take a look at what's there and see if it helps. Kyle [pc2]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Question
Copy data between SQL and Oracle 1
Replies
7
Views
166
dhookom
dhookom
Andrzejek
  • Locked
  • Question
Data Type in ADODB.Recordset
Replies
6
Views
408
strongm
strongm
IcarusHallsorts
  • Locked
  • Question
I have a column of data in Column A
Replies
3
Views
197
Andrzejek
Andrzejek
monyi
  • Locked
  • Question
Extracting Data from XML Node
Replies
0
Views
115
monyi
monyi
Kymenglish
  • Locked
  • Question
Automated data entry code in MS Excel VB - Edge code how to hit enter to remove popups
Replies
3
Views
216
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top