• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 405
  • Last Modified:

Excel number formatting

Hi,

I extract data into excel and numbers are appearing in different format as I want.
as attached.
sample1.jpg
0
amq10
Asked:
amq10
1 Solution
 
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
0
 
amq10Author Commented:
Hi teylyn,

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

find attached the excel sheet
Sample.xlsx
0
 
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 )?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now