Dear All of the fellow here
How to make every character of "0" (zero) invisible even thought this is come from a result of a formula?
but this is not happened in "10,200,...etc"
Need your help here
Dear All of the fellow here
How to make every character of "0" (zero) invisible even thought this is come from a result of a formula?
but this is not happened in "10,200,...etc"
Need your help here
Last edited by azbi; 07-12-2013 at 02:39 AM.
Try
Formula:Please Login or Register to view this content.
Dear Steve
where should I put?
I mean, if zero come from a calculation from formula automatically become invisible. any idea?
Please show me the formula you are currently using or perhaps attach a sample spreadsheet...
Does this help?Formula:Please Login or Register to view this content.
Last edited by Steve N.; 07-11-2013 at 11:05 PM.
Maybe use a custom number format...
0;;;@
HTH
Regards, Jeff
using condition format,
if equal to zero, make the text become white?
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
For Excel 2003 perhaps Tools -> Options select "View" tab and remove marker from "Zero values" box.
Alf
In +2003 version..
File > Option > Advance > Uncheck below option..
12-07-2013 11-26-01 AM.png
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
Dear All of the fellow here
Thanks for your guidance, its work
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks