# Get instant live expert help on I need help with excel decimal separator

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

I need to format my numbers so that the period is the thousand separator and the comma is the decimal separator.
Solved by S. J. in 29 mins
Create the following items in the Values-area, which will be used to answer Q1-Q4. o Number of transactions (using the COUNT function). Format the column with a ,000 separator and do not include any decimal places. Average of quantity purchased per transaction. Format the column with a ,000 separator and show two (2) decimal places). Average of unit price. Format the column with a currency format, e.g., 1234 should show as \$1,234.00, and showing two (2) decimal places. Total dollar value of transactions for the sector. Format the column with a currency format, e.g., 1234 should show as \$1,234.00, and showing two (2) decimal places.
Solved by V. A. in 29 mins
Excel 365: importing csv file (with power query?): First row: Header (text) row 2 - end: different datatypes (can be a text, date, decimal etc.) Problem I have: If I use the automatic datatype identification, it is all converted as a text independent from the real datatype. If I edit it by myself, I can choose the datatype "decimal", but then all decimal values (e.g. 25.1) are converted to "251". That means the decimal separator is gone. For my purpose the automatic datatype identification is mandatory, because I have dozens of columns and I can not edit every column by myself...
Solved by A. A. in 29 mins
Cannot get 1000s separator on my excel on MacBook Air, `I have lates Office 365
Solved by A. D. in 16 mins
hi, i need to use comma separator as per US standards
Solved by K. A. in 27 mins