Transferring from one form to another
 

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.

Transferring from one form to another
 

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

--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"Helpme" wrote:

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.

Transferring from one form to another
 

=RAW!F1
Replace the above link with this: =IF(RAW!F1="","",RAW!F1)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,600 Files:362 Subscribers:60
xdemechanik
---
"Helpme" wrote:
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.

Transferring from one form to another
 

Max,

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

Barb Reinhardt


"Max" wrote:

=RAW!F1
Replace the above link with this: =IF(RAW!F1="","",RAW!F1)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,600 Files:362 Subscribers:60
xdemechanik
---
"Helpme" wrote:
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.

Transferring from one form to another
 

.. 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
---

Transferring from one form to another
 

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

"Max" wrote:

=RAW!F1
Replace the above link with this: =IF(RAW!F1="","",RAW!F1)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,600 Files:362 Subscribers:60
xdemechanik
---
"Helpme" wrote:
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.

Transferring from one form to another
 

Okay i also tried this and it does work period. Let me tell you exactly what
i am doing, we work with a program called MAS 90 and we go in and export our
orders into excel we get a excel sheet and copy and paste it onto a template
sheet thats where the raw form and order form all are and in the order form
it is set up with a name address and phone number and then if there isnt
anything under the first line in the address it puts a 0 there and in the
formula bar on the order form it say the =RAW!F1 like it is bringing
information over from the raw form into the order form. I dont want this
zero there i want it to be gone forever every time we update it i dont there
to be any zero

"Max" wrote:

.. 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
---

Transferring from one form to another
 

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

The earlier suggestion is a formula which will return "blanks" should RAW!F1
be blank/empty. I'm out here as to what's happening over there.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,600 Files:362 Subscribers:60
xdemechanik
---

Transferring from one form to another
 

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
---