Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Maltenrazer
 
Posts: n/a
Default letter Validation


hello, thank you for your reply.

i get an error message. i highlight the cells that i want, than i goto
data validation, custom and i then copy and past the formula u have
given me. when i click OK it says that the formula has an error in it.

please can you explain on how i should go about on solving this.

thank you


--
Maltenrazer
------------------------------------------------------------------------
Maltenrazer's Profile: http://www.excelforum.com/member.php...o&userid=16130
View this thread: http://www.excelforum.com/showthread...hreadid=275829

  #2   Report Post  
Arvi Laanemets
 
Posts: n/a
Default

Hi

Replace semicolons with commas in formula!


Arvi Laanemets


"Maltenrazer" wrote in message
...

hello, thank you for your reply.

i get an error message. i highlight the cells that i want, than i goto
data validation, custom and i then copy and past the formula u have
given me. when i click OK it says that the formula has an error in it.

please can you explain on how i should go about on solving this.

thank you


--
Maltenrazer
------------------------------------------------------------------------
Maltenrazer's Profile:

http://www.excelforum.com/member.php...o&userid=16130
View this thread: http://www.excelforum.com/showthread...hreadid=275829



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Validation Window? Ken Excel Discussion (Misc queries) 1 January 11th 05 11:48 PM
Excel2000: Custom data validation and named ranges Arvi Laanemets Excel Discussion (Misc queries) 9 December 10th 04 08:05 PM
Letter format Ratowl Excel Discussion (Misc queries) 3 December 5th 04 01:23 AM
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? Arvi Laanemets Excel Discussion (Misc queries) 0 December 2nd 04 12:29 PM
letter Validation Maltenrazer Excel Worksheet Functions 1 November 6th 04 09:30 AM


All times are GMT +1. The time now is 01:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"