| Subject | Re: numbers as text |
| From | Charlie <tm@tc.com> |
| Date | Tue, 08 Apr 2025 09:48:43 -0400 |
| Newsgroups | dbase.getting-started |
Hi Lee.. My banking account is getting out of hand and I'm just trying to get a better way to organize it! NOT.... Just fooling. I am working with coin mintages and in some cases values for a numismatic cataloging program I've been working on. I have tried this.. function @R, picture 999,999,999,999 but that doesn't work. Instead of 63,888,444 I get weird, unorganized results. I am thinking there is a correct combination of functions but I am not sure which. Lee Grant Wrote: > Charlie, > > That should work, but how are you doing this and what version are you > using? By how are you doing this, I mean are you entering the > format/picture code in the designer, or directly in the code without a > designer? > > I ask, because if you use any other formatting symbol, the @R must be > the last code. For instance, in one of my programs, I have the > entryfield having the text centered in the entryfield and also, > formatted for time, and the code in the editor looks like this: > > picture = "99:99" > function = "I@R" > > As you can see, the @R must be the last function code put in, so if you > have any other picture or function code going in, the last one need to > be the @R. I did this with dBASE 2019, but this should be the same for > earlier version, as far as I know. > > Only other reason, I have to ask. Is that number formatting too large? > Billions? Really? > > Hope this helps. > > Lee > > On 4/7/2025 2:18 PM, Charlie wrote: > > I have numbers as a string. Might have asked this before but forgot. I want to only use commas when user is working with them in entryfields or grids. . Otherwise store them in the table as a string with no commas. Using entryfields I have tried function @R 999,999,999,999 with no luck. Can this be done without showing the commas on blank fields? > | |