Showing questions for topic:

copy paste teks angka dengan firefox pada excel, merubah text jadi angka,bagaiman ini bisa terjadi. Sedangkan pada browser lain, teks angka 16 digit tetap tecopy utuh.

https://copilot.cloud.microsoft/chat/share/eyJzaGFyZUlkIjoiODM5MjRmMzctNmNlMS00MzAwLTgyOGYtZTU1Mzk4ODk4MTAyIiwiY29udmVyc2F0aW9uSWQiOiJiMjNhOWRjYy02YWNhLTQwYWYtYTMzZS05Mzg… (read more)

https://copilot.cloud.microsoft/chat/share/eyJzaGFyZUlkIjoiODM5MjRmMzctNmNlMS00MzAwLTgyOGYtZTU1Mzk4ODk4MTAyIiwiY29udmVyc2F0aW9uSWQiOiJiMjNhOWRjYy02YWNhLTQwYWYtYTMzZS05Mzg0OTFkYWUyN2EifQ%3D%3D

isinya: Dari gambar yang Anda kirim, nilai aslinya adalah: 3374156406260002 (16 digit) Perbedaan terjadi karena cara browser menyalin data dari halaman web berbeda, dan Excel juga memiliki batasan untuk angka panjang. Yang terjadi Hasil dari Chrome 3374156406260002 Excel menampilkan seluruh angka karena saat paste, datanya dianggap sebagai teks atau angka yang masih bisa ditampilkan apa adanya. Hasil dari Firefox 3,37E+16 Firefox kemungkinan menyalin data dengan format yang membuat Excel menganggapnya sebagai angka numerik, sehingga Excel menampilkannya dalam notasi ilmiah (scientific notation). 3,37E+16 artinya: 3,37 × 10^16 Bahaya yang lebih penting Excel hanya menyimpan 15 digit presisi untuk tipe angka (Number). Contoh: Nilai asli: 3374156406260002 Ketika dianggap angka oleh Excel, bisa berubah menjadi: 3374156406260000 Dua digit terakhir bisa hilang atau berubah tanpa terlihat jelas. Jadi meskipun tampilan hanya berbeda (3374156406260002 vs 3,37E+16), yang perlu dicek adalah apakah nilainya masih utuh. Cara mengecek Di Excel, klik sel hasil Firefox lalu lihat Formula Bar. Atau gunakan rumus: =TEXT(B6,"0") Jika hasilnya: 3374156406260000 berarti sudah terjadi pembulatan dan data tidak lagi identik dengan data asli. Cara yang aman untuk NIK Karena NIK adalah identitas, bukan bilangan yang dihitung, sebaiknya simpan sebagai teks: Cara 1 Sebelum paste, format kolom menjadi Text. Cara 2 Awali dengan tanda petik: '3374156406260002 Cara 3 Saat impor data, pilih tipe kolom Text. Dugaan pada kasus Anda Melihat screenshot: Data dari Chrome tampil lengkap 3374156406260002. Data dari Firefox tampil 3,37E+16. Kemungkinan besar: Chrome menyalin sebagai teks. Firefox menyalin sebagai angka. Excel mengubah angka 16 digit menjadi number dan menampilkan notasi ilmiah. Coba di Excel jalankan: =LEN(A5) =LEN(A6) dan =A5=A6 Hasil dari ketiga rumus tersebut akan langsung menunjukkan apakah kedua data masih identik atau salah satunya sudah mengalami pembulatan.

Open

firefox dont support open in background with reeder(feed app)

In previous versions, this feature supported background operation; however, since the latest update, opening an article in Reeder immediately triggers the browser to laun… (read more)

In previous versions, this feature supported background operation; however, since the latest update, opening an article in Reeder immediately triggers the browser to launch. Could you please check this in Firefox and restore the previous, more convenient behavior? Having the browser pop up every single time leads to unnecessary switching between tabs.

Open

URLs not preserved when pasting content into OneNote

The new 157 release broke something when pasting a webpage into OneNote. Previously when pasting, the complete URL was appended at the end of what was pasted: (web page … (read more)

The new 157 release broke something when pasting a webpage into OneNote.

Previously when pasting, the complete URL was appended at the end of what was pasted: (web page text and images) Pasted from <https://earthsky.org/tonight/longest-days-of-year-accompany-the-december-solstice/?mc_cid=1422e68d3a>

In 157, only the top web address is pasted: (web page text and images) From <https://earthsky.org>

Having the entire URL to the actual pasted page saved a step. Now I have to copy the address out of the address bar and copy it to OneNote manually.

Open

157: Clipboard SourceURL only contains domain?

I use a note keeping app that saves copied snippets from the web with the source URL. I've noticed that Firefox has recently started stripping URLs - the SourceURL field … (read more)

I use a note keeping app that saves copied snippets from the web with the source URL. I've noticed that Firefox has recently started stripping URLs - the SourceURL field now only contains the domain in the html format payload.

For instance if I copy a snippet from a wikipedia page in Firefox and view the HTML format information stored on the clipboard, I see:

Version:0.9 StartHTML:00000133 EndHTML:00000344 StartFragment:00000167 EndFragment:00000308 SourceURL:https://en.wikipedia.org

Cat

Previously, the source url field would contain the full URL for the page, and if I try in Edge, it still copies the full URL for instance:

Version:0.9 StartHTML:0000000150 EndHTML:0000001067 StartFragment:0000000186 EndFragment:0000001031 SourceURL:https://en.wikipedia.org/wiki/Cat

Cat


The text/x-moz-url-priv field also only contains the domain now instead of the full URL. Is there a setting or something to restore the previous behavior of storing the whole source URL to clipboard?

Open

Link being stripped

After a recent update - I can no longer copy a title from an article and get the full URL to paste in OneNote. For example with this article - If copied it and pasted it… (read more)

After a recent update - I can no longer copy a title from an article and get the full URL to paste in OneNote.

For example with this article - If copied it and pasted it in OneNote it would appear this way

How to Link Notes in OneNote (2026) From <https://www.usecarly.com/blog/how-to-link-notes-in-onenote/>

But now I get this:

How to Link Notes in OneNote (2026) From <https://www.usecarly.com>

I made no changes to OneNote and in settings there: Include link to source when pasting from the Web is checked.

This function is working in Chrome as usual. But no longer in Firefox.

What setting can I change?

Thank you

Open

I cannot open links in Firefox. When I tap a link, it does not open correctly or does not give me the option to choose another application. I would like to open links using a different app instead of Firefox. Please help me change this setting

When I tap a link, it opens in Firefox, but I want to be able to open the link with another application. I can't find how to change this setting on my Android phone. Plea… (read more)

When I tap a link, it opens in Firefox, but I want to be able to open the link with another application. I can't find how to change this setting on my Android phone. Please tell me how to choose another app for opening links.

Open 1 51

Links not functioning repeatedly

Hi. I have noticed over the last few weeks, so maybe related to the 155. If I am on a website with links the browser doesn't respond to many links, in fact no links most … (read more)

Hi. I have noticed over the last few weeks, so maybe related to the 155.

If I am on a website with links the browser doesn't respond to many links, in fact no links most of the time.

This only happens usually after the first link has worked. There is no data in the status bar for the link.

If I close the link I have opened, always in a new tab, then other links will then work.

It is as it the details of the URL path are not being recognised, almost like something is saying : Hey you are already looking at this site don't be greedy and expect me to open multiple page with the same domain.

I did see a similar query a while ago but can't find it.

So not a critical problem.

Oh yes. When this happens I also cannot right-click to open in a new tab as an alternative.

Thanks

Hope everyone is having at least a half decent day. :)

Solved Locked 1 10

Firefox doesn't allow links to be opened from other programs

Seemingly any program that has links that when clicked there, redirect and open a new tab in your browser just, do nothing now that I've swapped to Firefox? No indication… (read more)

Seemingly any program that has links that when clicked there, redirect and open a new tab in your browser just, do nothing now that I've swapped to Firefox? No indication or response on Firefox, it just acts like nothing happened. I don't even know why something this simple would break, let alone what WOULD break it.

Open

Useless changes

The recent changes to the right-click menu on YouTube are a backward step. The menu is now cluttered with options I don't use, while the useful “Open in New Window” optio… (read more)

The recent changes to the right-click menu on YouTube are a backward step. The menu is now cluttered with options I don't use, while the useful “Open in New Window” option has disappeared. I regularly use this function and having to use Shift+click instead is unnecessarily inconvenient. Please consider restoring “Open in New Window” to the context menu. Not every new feature is an improvement, and sometimes the simple, familiar options are the ones users actually want.

Solved 1 10

how do i get copy command back when right click

when I get new tab I don't seem to be able to connect with web site I am asking for. In addition right click not dot get the menu of command. I just updated with 154.0 … (read more)

when I get new tab I don't seem to be able to connect with web site I am asking for. In addition right click not dot get the menu of command. I just updated with 154.0

Open 5 20

ALL saved toolbar web links as well as others saved in "other" will not open - rebooted, save mode, nothing-cant get to bank acct to pay bills also

see above- nothing works I have not installed most recent update as I have been at a hospital 9 days with wife in ICU I really need to pay bills very soon and return to n… (read more)

see above- nothing works I have not installed most recent update as I have been at a hospital 9 days with wife in ICU I really need to pay bills very soon and return to normal, loving on her and loving Firefox loyal 10 yr user- hope you can help will check tomorrow-thanks

Mark Dombrowsky dallas Tx

Open 1 60

A standard link to websites never works

When I am in a web page and am asked to link to another URL using the standard link system, it never works. It is a black image framing choices of which browser I want t… (read more)

When I am in a web page and am asked to link to another URL using the standard link system, it never works. It is a black image framing choices of which browser I want to use and "Firefox" is usually highlighted. When I click on the link, nothing happens. I want to know how to make it work, because the actual URL is seldom if ever listed. I'll send an image to help (I hope).

Open 1 50

mailto isn't opening an email mail document even though firefox is chosen in prefs.

Mac Mini Pro M4, MacOs 26.6.1, Firefox 153.0.4 When I click on a "mailto" link I get a pop up that says select an app for mailto. In this popup, Firefo… (read more)

Mac Mini Pro M4, MacOs 26.6.1, Firefox 153.0.4 When I click on a "mailto" link I get a pop up that says select an app for mailto. In this popup, Firefox shows as the suggested app. I click on it and I get a message that says This Can Be Changed in Firefox Settings. When i select Firefox in this popup nothing happens. When I look at the mailto setting in Firefox it clearly says Firefox. Help. Thanks, Pete D.

Open 1 60

Firefox does not open links in Thunderbird emails, but Chrome do

Windows 10, Firefox 131, Thunderbird 91.13 I set Firefox as default browser - I can't open links from Thunderbird in Firefox. I set Chrome as default browser - I can open… (read more)

Windows 10, Firefox 131, Thunderbird 91.13 I set Firefox as default browser - I can't open links from Thunderbird in Firefox. I set Chrome as default browser - I can open links from Thundebird in Chrome. How can I fix or debug this?

Open 4 50