Number formatting does not seem to work

[marcvanderpeet12]

Dear all,

I have the following Excel.

In sheet BE in formatted the sections C68:N78 as number (with two digits).






However, the data keeps showing more than 2 digits. Any thoughts on what goes wrong here...

 

[ETAF]

a spreadsheet would be more useful

difficult to tell from images

how are the numbers obtained - using a formula , may produce TEXT and so its not numbers but text in the cells - cant tell as the cells seem tobe centre aligned
numbers are usually right - text left

 

[bosco_yip]

1] Duplicate post >>

How to use conditional formatting with parameters

Dear all, I have the following Excel sheet. In the tab "BE" there's an area that is using conditional formatting (fe, section C68: N78). I would like to try different ranges for conditional formatting. So ideally I want to be able to fill in data in the range Q68 to S 74 after which different...

chandoo.org

2] Please stick on the original post

3] This post is closed.

 

[Luke M]

After review, this question is a follow-up to previous; not a duplicate. Thread re-opened.

 

[pecoflyer]

Please post a sample sheet. Pictures are useless to work with. Thx