Excel number formatting

Hi,

I extract data into excel and numbers are appearing in different format as I want.
as attached.
sample1.jpg
amq10Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

select the cell and on the Home ribbon select "General" in the number format drop-down.

In your screenshot, the number format is showing negative values in parentheses, like

-123 is formatted to show as (123)

You can change the number format for the cell with the formatting options for the cell.

There are many ways to format numbers, and negative values can be displayed with many options: leading - sign, red, round brackets and more. You can change the format with the formatting settings for the cell.

Right-click the cell and select "Format Cells". Then select any of the pre-defined number formats or create your own preferred format.

cheers, teylyn
amq10Author Commented:
Hi teylyn,

sorry but ( ) is not my issue. the issue here is that number separator (,).

find attached the excel sheet
Sample.xlsx
Brian PiercePhotographerCommented:
but the value is -153,804.5 - so why would it appear as 15,380.45 - (unless you divide it by 10 that is )?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.