XL2BB - Excel Range to BBCode 2.1

[arthurbr]

Just been trying XL2BB and works great.
Drawback is I'm using European separators. Will they adapt ( to non European settings) when pasting to the board, and the other way round ? (I admit I did not read all the answers in this thread)
I pasted from the board to my Excel version and had to do some Ctrl+H magic...

 

[Fluff]

It will convert your formulae into US formulae (except conditional format formulae) but will not convert them to your local settings when you copy from the board.

 

[arthurbr]

Thanks Fluff. I suppose there is no way that can be arranged ?

 

[Fluff]

Fraid not. Suat looked at various options, but there are simply too many possible scenarios.

 

[etaf]

i cant seem to get conditional formatting icons to show with Xl2BB

see this entry

Formula for using with Icon Sets

Hi there I am trying to create a formulae with conditional formating using the i con sets, this is what i want it to do I have a cell called outstanding stock say c3, i am trying to do a formulae that says if c3 is not equal to 0 the the condional formatin will but the yellow ! mark next to...

www.mrexcel.com

you can see the XL2BB entry and the image

 

[Fluff]

I don't think they have never appeared.

 

[etaf]

thanks Fluff, not something i have done then - cheers

 

[Sufiyan97]

Hii Need help, can't add XL2BB

 

[MARK858]

Either
1) place the Addin in a Trusted Location

Add, remove, or change a trusted location in Microsoft Office - Microsoft Support

A trusted location is a folder that contains files you're confident are safe. See how to add, remove, or change a trusted location in Microsoft Office.

support.microsoft.com

or
2} Right click the XL2BB file, click properties, click the General tab and see if near the bottom you have an Unblock checkbox... if you do check it.

 

[Sufiyan97]

Hiii Mark,

Tried option 2 and that worked, Thank you very much!