Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / March 2006

Tip: Looking for answers? Try searching our database.

Excel Programming and Pocket Excel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
No Name - 24 Mar 2006 03:11 GMT
Not sure if this is the right newsgroup.  If not could someone direct me to
the right group.

I'm having problems with a Worksheet that I created.  Its a bit tricky and
was wondering if there is anyone here that is good with Excel give me a hand
here.

The situation is I'm a sales rep and I have created a list of items i sell
in a master list that has price, item # and UPC.

When I am scan the UPC with a barcode the cell has to be in a text format.
When I just enter in a item # by hand the cell has to be a number.

That is the situation i am having on the desktop.

When I copy the file to the IPAQ HX2750 all i can do is enter the item
number regardless of the cell being in text or number format.

If you think you can help please email me and I'll send my file over to you.

Thanks in advance.
thebubblejungle - 24 Mar 2006 03:20 GMT
> Not sure if this is the right newsgroup.  If not could someone direct me to
> the right group.
[quoted text clipped - 17 lines]
>
> Thanks in advance.

Are you wanting the barcode to be in text fomat? If so, prefix your
barcodes with a ' character and they'll be converted to text.

m
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.