Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 --- |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 --- |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 --- |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transferring Data | Excel Worksheet Functions | |||
transferring data | Excel Discussion (Misc queries) | |||
transferring cells.. | Excel Discussion (Misc queries) | |||
transferring jpegs | Excel Discussion (Misc queries) | |||
transferring files | Excel Worksheet Functions |