Cell formatting problem

kramart

New Member
Joined
Apr 3, 2014
Messages
39
Hi,

I have one cell in my spreadsheet "1" that doesn't react to formatting. In the spreadsheet "1" there are many cells that have links to another spreadsheet "2" and if the values in that spreadsheet "2" are zero then by using cell formatting in the spreadsheet "1" instead of values "0" there are symbols "-".
There is one cell that keeps displaying "0" no matter what I try to do. I have tried text to columns option, different cell formatting options but nothing works. I think that this might be related to the spreadsheet "2" or maybe the link (?) because if I paste the link to a cell that normally displays "-" it changes to "0" ??? However other links from the same workbook where is the spreadsheet "2" don't cause this problem !!! :confused:

Any suggestions will be much appreciated!

Cheers,

A
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Dear Kramart

Please see if the "0" is showing some decimals in the formula bar , u will have to rounddown it to show "-".
Also check whether the "0" is of Decimal data type & not Text

Hope it helps
 
Upvote 0
Thanks,

The formula in other spreadsheet had the 0 in double quotes hence returning text not number.

Cheers,

A
 
Upvote 0

Forum statistics

Threads
1,223,909
Messages
6,175,312
Members
452,634
Latest member
cpostell

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top