Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Get rid of the zeros?!
Hi, I have got two worksheets and have set-up some simple formulas that just copy whatever is typed into a cell on the first sheet into the same cell onthe second sheet. e.g. =Registers!B58 However, if nothing is typed into the cell then a pesky 0 appears on the second sheet. Is there anyway of preventing this? Many thanks, Mark. -- mevetts ------------------------------------------------------------------------ mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130 View this thread: http://www.excelforum.com/showthread...hreadid=494651 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Get rid of the zeros?!
=IF(Sheet1!A1="","",Sheet1!A1)
-- Kind regards, Niek Otten "mevetts" wrote in message ... Hi, I have got two worksheets and have set-up some simple formulas that just copy whatever is typed into a cell on the first sheet into the same cell onthe second sheet. e.g. =Registers!B58 However, if nothing is typed into the cell then a pesky 0 appears on the second sheet. Is there anyway of preventing this? Many thanks, Mark. -- mevetts ------------------------------------------------------------------------ mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130 View this thread: http://www.excelforum.com/showthread...hreadid=494651 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Get rid of the zeros?!
=if(Registers!B58="","",Registers!B58)
mevetts wrote: Hi, I have got two worksheets and have set-up some simple formulas that just copy whatever is typed into a cell on the first sheet into the same cell onthe second sheet. e.g. =Registers!B58 However, if nothing is typed into the cell then a pesky 0 appears on the second sheet. Is there anyway of preventing this? Many thanks, Mark. -- mevetts ------------------------------------------------------------------------ mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130 View this thread: http://www.excelforum.com/showthread...hreadid=494651 -- Dave Peterson |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Get rid of the zeros?!
Fantastic, thanks for the help. -- mevetts ------------------------------------------------------------------------ mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130 View this thread: http://www.excelforum.com/showthread...hreadid=494651 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Get rid of the zeros?!
Hi,
You may use conditional formatting on the Format toolbar. Regards, "mevetts" wrote: Hi, I have got two worksheets and have set-up some simple formulas that just copy whatever is typed into a cell on the first sheet into the same cell onthe second sheet. e.g. =Registers!B58 However, if nothing is typed into the cell then a pesky 0 appears on the second sheet. Is there anyway of preventing this? Many thanks, Mark. -- mevetts ------------------------------------------------------------------------ mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130 View this thread: http://www.excelforum.com/showthread...hreadid=494651 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spliting a number with leading zeros | Excel Discussion (Misc queries) | |||
Deleting Lead Zeros | Excel Worksheet Functions | |||
Creating formulas that allow the solutions to start with zeros. | Excel Discussion (Misc queries) | |||
How do I force leading zeros in an Excel cell? | Excel Discussion (Misc queries) | |||
Leading zeros | Excel Discussion (Misc queries) |