Home

How to query differentiate or query cell categories located in one column in Excel?

hassan bach
Visitor

I'm drying to find a way to differentiation between cells with "general" category, for example, vs "number" category, which are located in the same column.

For example between digit "5" located in cell A1 with category "General" and another digit "5.00" locate in cell A2 with category "Number".

2 Replies
i would recommend asking this question in the Excel forum so that it will be seen by people that have deep expertise with that specific application

Hi @hassan bach

 

In case this hasn't been reposted in the Excel forum or answered as yet, here's a great resource to help you with this question.

 

https://support.office.com/en-us/article/available-number-formats-0afe8f52-97db-41f1-b972-4b46e9f1e8...

 

Format

Description

General

The default number format that Excel applies when you type a number. For the most part, numbers that are formatted with the General format are displayed just the way you type them. However, if the cell is not wide enough to show the entire number, the General format rounds the numbers with decimals. The General number format also uses scientific (exponential) notation for large numbers (12 or more digits).

Number

Used for the general display of numbers. You can specify the number of decimal places that you want to use, whether you want to use a thousands separator, and how you want to display negative numbers.

 

Hope that helps.

 

Cheers

Damien

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies