Transferring from one form to another

H

Helpme

I am transferring information from a raw form to an order form and when i go
to the order form i get a 0 and in the formula bar it says =RAW!F1. how can
i get rid of this 0 permanetly.
 
B

Barb Reinhardt

You could put a conditional format on it and if the result is zero, format it
with the white font.
 
B

Barb Reinhardt

Max,

I thought about doing that, but if there are any calculations tied to this
cell, it could "gack".

Barb Reinhardt
 
M

Max

.. but if there are any calculations tied to this cell, it could "gack".
Possibly so, Barb. Then again it's one of the usual options availed for neat
appearances when it comes to simple link formulae. One other way I'd consider
is to simply switch off zeros display in the sheet, via Tools > Options >
View tab.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,600 Files:362 Subscribers:60
xdemechanik
---
 
H

Helpme

Okay i tried that and it doesnt delete the formula permanetly once i save it
and then redo it, it brings the 0 back.
 
M

Max

Okay i also tried this and it does work period.
Good to hear that. Any relief is good, albeit temp.

As for your underlying intents, suggest you try posting in .programming.
Paste the underlying code in your posting
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,600 Files:362 Subscribers:60
xdemechanik
---
 
Top