Cell Format to Currency not working (2024)

‎Apr 21 202206:00 AM

@Megabouw

Thanks. The values in D3:D5 are left-aligned, a tell-tale sign that Excel treats them as text.

I notice that the values contain a point (dot). If your computer uses comma as decimal separator, Excel won't recognize the points. So select D3:D5 and replace point with comma. Does that make a difference?

See Also
Understanding Currencies | PIMCOHow to Read and Calculate Currency Exchange RatesHow to calculate exchange rates | Western UnionConvert Currency in Google Sheets: A Step-by-Step Guide
Cell Format to Currency not working (2024)
Top Articles
The Day Trading Success Rate - The Real Answer and Statistics - Trade That Swing
Forex vs Stocks: Which is a Better Option for Beginners?
Tattoos For Grandchildren Names
5+ Smart Hacks That’ll Make Upcycling A Piece Of Cake
The Best Restaurants in Morristown
The Best Restaurants in Morris County NJ | Kimberly Brechka
How to beat the Tibia Mariner in Elden Ring
Spider-Man 4 Theory Confirms Iron Man's Replacement In The Worst Way
14 Best Sites To Instantly Swap Crypto for the Lowest Fees
Create Turnitin Account
Latest Posts
Answers to Frequently Asked Questions | AAA Roadside Assistance
[Solved] Which one of the following is not a function of money?
Article information

Author: Trent Wehner

Last Updated:

Views: 5751

Rating: 4.6 / 5 (56 voted)

Reviews: 87% of readers found this page helpful

Author information

Name: Trent Wehner

Birthday: 1993-03-14

Address: 872 Kevin Squares, New Codyville, AK 01785-0416

Phone: +18698800304764

Job: Senior Farming Developer

Hobby: Paintball, Calligraphy, Hunting, Flying disc, Lapidary, Rafting, Inline skating

Introduction: My name is Trent Wehner, I am a talented, brainy, zealous, light, funny, gleaming, attractive person who loves writing and wants to share my knowledge and understanding with you.