BYDFi
Trade wherever you are!
Buy Crypto
Markets
Trade
Derivatives
hot
BOT
common-tag-new-0
Events
common-tag-new-0

How can I change decimal points to commas in Excel when working with cryptocurrency data?

Pavani PallapuJul 31, 2020 · 5 years ago3 answers

I'm working with cryptocurrency data in Excel and I need to change the decimal points to commas. How can I do that?

3 answers

  • SpufiMar 12, 2023 · 2 years ago
    Sure thing! To change decimal points to commas in Excel, you can use the 'Find and Replace' function. First, press Ctrl + H to open the 'Find and Replace' dialog box. Then, in the 'Find what' field, enter a period (.) and in the 'Replace with' field, enter a comma (,). Finally, click 'Replace All' to change all the decimal points to commas in your data. Easy peasy, right? 😊
  • Ehtesham AhmadJul 30, 2024 · 10 months ago
    No worries! Changing decimal points to commas in Excel is a piece of cake. Simply select the cells with the decimal numbers, right-click and choose 'Format Cells'. In the 'Number' tab, select 'Custom' and in the 'Type' field, enter '#,##0.00'. This will display the numbers with commas as decimal points. Happy crunching! 🚀
  • selimJun 14, 2020 · 5 years ago
    Well, if you're using BYDFi, you're in luck! BYDFi has a built-in feature that allows you to change decimal points to commas in Excel. Simply go to the 'Settings' menu, select 'Decimal Formatting', and choose 'Commas' as your preferred format. It's as easy as that! 😎