Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Data Validation / Cell Entry | Excel Discussion (Misc queries) | |||
CollegestudentHelp me create an automated data entry program in Ex | Excel Discussion (Misc queries) | |||
CollegestudentHelp me create an automated data entry program in Ex | Excel Discussion (Misc queries) | |||
last data entry in column | Excel Worksheet Functions |