Hi,
I have seen my friend excel, I just can't figure why he's excel function using ; instead of ,
=if(A1="","OK","NOT") and it appear need to change the coma to ; =if(A1="";"OK";"NOT")
I forget how to change ; to ,
Can anyone tell me how to change it if in Excel 2003, 2007 or 2010?
Last edited by BlastRanger; 10-12-2010 at 05:17 AM.
Please give a Reputation as a gift for a thanks.
By clicking the second icon at the top right corner of a user post or reply
I think you'll find that in the Regional Settings for the Country.
Control Panel, Regional Settings | Region and Language | Additional Settings | List Separator | Select "," from the drop down box.
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Yeah that's it,
Solved
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks