need help with coding ( easy )

jbeaucaire

Well-known Member

Joined

May 8, 2002

Messages

6,012

• Jul 13, 2009

• #2

Perhaps using the standard notation for Excel of <= and >= would work for you.

 

Upvote 0

D

danmen

Board Regular

Joined

Jan 15, 2009

Messages

217

• Jul 13, 2009

• #3

the other parts of the spreadsheet have the ≥ and ≤ notations so I would prefer sticking to the same, it's just the syntax of the line I'm missing, I searched the net a little and tried out a couple of things but nothing's worked so far =(

 

Upvote 0

D

danmen

Board Regular

Joined

Jan 15, 2009

Messages

217

• Jul 13, 2009

• #4

danmen said:

the other parts of the spreadsheet have the ≥ and ≤ notations so I would prefer sticking to the same, it's just the syntax of the line I'm missing, I searched the net a little and tried out a couple of things but nothing's worked so far =(

Click to expand...

anyone? =(

 

Upvote 0

jbeaucaire

Well-known Member

Joined

May 8, 2002

Messages

6,012

• Jul 13, 2009

• #5

I would personally would love to see examples of you using that non-standard character in working formulas. It would be a completely new feature, one I've tried in the past to no success and simply stayed with conventions...which is of course an option for you as well.

Care to use Excel Jeanie to post up some visible examples of the data you're referring to, I would be very interested to see it.

 

Upvote 0

Michael M

Well-known Member

Joined

Oct 27, 2005

Messages

21,898

Office Version

1. 365
2. 2019
3. 2013
4. 2007

Platform

1. Windows

• Jul 13, 2009

• #6

JB
Maybe the OP isn't using Excel.

Danmen
What version of Excel are you using.

Regards
Michael M

 

Upvote 0

ZVI

MrExcel MVP

Joined

Apr 9, 2008

Messages

3,875

Office Version

1. 2019
2. 2016
3. 2010

Platform

1. Windows

• Jul 13, 2009

• #7

In VBA you can set the required number format of selected cells as well:

Rich (BB code):

<font face=Courier New>
  Dim fmt As String, s As String
  s = """ " & ChrW(8805) & " """
  fmt = s & "0.00;" & s & "-0.00;" & s & "0.00"
  Selection.NumberFormat = fmt</FONT>

Use ChrW(8804) for LE symbol

 

Last edited: Jul 13, 2009

Upvote 0

W

wsjackman

Well-known Member

Joined

Jun 19, 2008

Messages

2,465

• Jul 13, 2009

• #8

the unicode(2265) is the greater than or equal to symbol
unicode(2264) is the less than or equal to symbol


use insert symbols to insert the ≤ into a cell
copy the ≤

select the cells you want to format
goto format cells custom and paste the ≤ where ever you want it
At least it works in 2007 I do not know about other versions

 

Upvote 0

Punchin

Board Regular

Joined

Dec 12, 2008

Messages

65

• Jul 13, 2009

• #9

Tested on 2003. Works fine as long as you put a 0 where you want the numbers to show up. (ex: ≤ 0)

 

Upvote 0

D

danmen

Board Regular

Joined

Jan 15, 2009

Messages

217

• Jul 14, 2009

• #10

Punchin said:

Tested on 2003. Works fine as long as you put a 0 where you want the numbers to show up. (ex: ≤ 0)

Click to expand...

thanks to all =)

the coding works beautifully

greetings from Canada
Danny

 

Upvote 0