Hi All,
1 sheet used to contain all my workings etc
2 sheet reads from first sheet but I only want it to show certin iformation
I am trying to format read only sheet cells to not show £ when cell is 0 value
Thanks
Taz
Hi All,
1 sheet used to contain all my workings etc
2 sheet reads from first sheet but I only want it to show certin iformation
I am trying to format read only sheet cells to not show £ when cell is 0 value
Thanks
Taz
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Try
Custom format of
[>0]£#,##0.00;General
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks