smozgur

XL2BB - Excel Range to BBCode 1.2.8

No permission to download

smozgur

BatCoder
Joined
Feb 28, 2002
Messages
1,106
Hi, @narendra

I saw your review for XL2BB. Thanks for your review.

However, I can't post a sample in the reviews section, that's why I am sending here. It would be also a generic answer for the question you asked.

narendra said:
Can we also capture actual Result(value) and Cell Number Formats?

For example, cell A1 has formula '=1500*0.15784' where the result value will be '236.76' and cell number format is '#,##0', therefore the result displayed on the table is '237'.

Did you test this before posting your review? Because, XL2BB works exactly like this. See the following sample please.
Book1
A
1237
Sheet1
Cell Formulas
RangeFormula
A1A1=1500*0.15784

However, if you mean BB2XL, which means when you copy from this web page and paste in the Excel worksheet, then I'm afraid it is not possible, because the cell contains formula, and also transferred as a formula to the Excel worksheet. It is basically not possible to transfer cell number formats to the worksheet.
You'll see even Microsoft Excel Online doesn't work like this if you try to create the formula in A1 and format the cell in Excel Online, then copy and paste into Excel desktop application. It won't transfer the number formats.

By the way, if you don't need the formulas to be transferred to Excel, but values & formatting, then Alt + Click on the copy button as it is explained in the tooltip:
1605318026296.png


Then it will paste the cell values as you see them in the XL2BB mini-sheet. This is also how Microsoft Excel Online works.

Hope this helps.
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Watch MrExcel Video

Forum statistics

Threads
1,114,205
Messages
5,546,543
Members
410,745
Latest member
citrictango
Top