Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

How to format a number to my desired outcome?

0

this is my question

for applying to entire sheet

A whole number must be shown without decimal point.

Number with decimal point must be shown up to 2 decimal point.

A negative number must be shown in color red with the negative sign.

How to do using using the FORMAT CONDITIONS for entire sheet?

i cufrently did "selecting the entire sheet, then chose format conditions, under number, i selected custom , and typed 

"General;[Red]-General;;@"

but it seems to be nor 100% correct

Post Edited
Tags: Tags were updated to reflect the topic of the question.
Answer
Discuss

Answers

0

You were on the right path. Yes, select the entire sheet. Then press Format > Format Cells. In the dialog that opens select the 'Number' tab but now you should select the second choice, 'Number'. You can select how to display negative numbers.

Unfortunately, you can't choose different formats for whole numbers and those with decimal digits. Such formatting isn't recommended because it would play havoc with your number columns. Remember from school? The decimal points of numbers in a column must be vertically aligned. Excel achieves this result by having an equal number of digits to the right of the point. This is the standard for all accounting work, too.

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login