ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do I create a data entry edit mask? (https://www.excelbanter.com/excel-discussion-misc-queries/30223-how-do-i-create-data-entry-edit-mask.html)

Jeff Perreault

how do I create a data entry edit mask?
 
I've been tasked with saving excel data as a .csv, then uploading the data
into an ingres database. There are numerous needs for special formatting in
the ingres database, and I'm trying to devise methods to deal with some of
them...

- a numeric field required a blank at the end of it (12345b)
- blank values in the cells that need to be converted either to null or to
-1E38
- 15 character numbers that need to stay as discrete numbers, not go to sci.
not.

Many of these seem like they could be resolved with some edit masks, but I
can't locate any decent coverage of the topic in the online help. Am I not
looking in the right place? Or is there a separate source for documentation
that I should be using?

Jeff


All times are GMT +1. The time now is 02:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com