Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
replacing 0's
Have a spreadsheet with "several" 0.00 in cells.
Tried -- Find 0.00 and Replace with - (dash). Keep getting message that match cannot be found. Not sure what I'm doing wrong but would like to replace all the 0.00 with either a dash or leave blank. thanks, L. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
replacing 0's
Format the cells as Accounting
-- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "L.S." wrote in message ... Have a spreadsheet with "several" 0.00 in cells. Tried -- Find 0.00 and Replace with - (dash). Keep getting message that match cannot be found. Not sure what I'm doing wrong but would like to replace all the 0.00 with either a dash or leave blank. thanks, L. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
replacing 0's
If your cells are 0's formatted as 0.00, Find/Replace will not find 0.00 as
the cells do not contain 0.00, the cells contain 0. It appears you're confusing the cell content, 0, with the formatting of the cell as 0.00 for display purposes. You can format your cells with 0 to display as - (dash) with custom formatting of #;-#;- or as blank with #;-#; Tyro "L.S." wrote in message ... Have a spreadsheet with "several" 0.00 in cells. Tried -- Find 0.00 and Replace with - (dash). Keep getting message that match cannot be found. Not sure what I'm doing wrong but would like to replace all the 0.00 with either a dash or leave blank. thanks, L. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
replacing 0's
Worked. thanks
Is there a reason why the Find and Replace didn't work with currency format? L. "Sandy Mann" wrote in message ... Format the cells as Accounting -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "L.S." wrote in message ... Have a spreadsheet with "several" 0.00 in cells. Tried -- Find 0.00 and Replace with - (dash). Keep getting message that match cannot be found. Not sure what I'm doing wrong but would like to replace all the 0.00 with either a dash or leave blank. thanks, L. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
replacing 0's
Thanks for the info.
Learn something new everyday. "Tyro" wrote in message . net... If your cells are 0's formatted as 0.00, Find/Replace will not find 0.00 as the cells do not contain 0.00, the cells contain 0. It appears you're confusing the cell content, 0, with the formatting of the cell as 0.00 for display purposes. You can format your cells with 0 to display as - (dash) with custom formatting of #;-#;- or as blank with #;-#; Tyro "L.S." wrote in message ... Have a spreadsheet with "several" 0.00 in cells. Tried -- Find 0.00 and Replace with - (dash). Keep getting message that match cannot be found. Not sure what I'm doing wrong but would like to replace all the 0.00 with either a dash or leave blank. thanks, L. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
replacing a #na | Excel Discussion (Misc queries) | |||
Replacing #N/A | Excel Worksheet Functions | |||
Replacing #DIV/0! With Just 0 | Excel Worksheet Functions | |||
Replacing #N/A with a '0' (zero) | Excel Worksheet Functions | |||
Help Replacing all ( * ) with ( - ) | Excel Discussion (Misc queries) |