If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Number formating
The results from one field in my query is in this format: 2316.52
I need that to look like this: 0000231652 Which is 10 characters long, zero filled, and without the decimal. Can anyone help? -- Thanks from a frustrated accountant |
#2
|
|||
|
|||
On Fri, 26 Aug 2005 09:20:02 -0700, AccessNewbie wrote:
The results from one field in my query is in this format: 2316.52 I need that to look like this: 0000231652 Which is 10 characters long, zero filled, and without the decimal. Can anyone help? In your query: NewColumn:Format([FieldName]*100,"0000000000") -- Fred Please only reply to this newsgroup. I do not reply to personal email. |
#3
|
|||
|
|||
yay i'm excited i can actually help!
select the cell you would like to format right click, then select the option "format cells..." make sure the number tab is selected, and scroll down to the category "custom" in the entry space labeled "Type:", type 10 zeros or however many you want finish by selecting ok "AccessNewbie" wrote: The results from one field in my query is in this format: 2316.52 I need that to look like this: 0000231652 Which is 10 characters long, zero filled, and without the decimal. Can anyone help? -- Thanks from a frustrated accountant |
#4
|
|||
|
|||
my apologies i thought you were using excel, so sorry again
"ashley" wrote: yay i'm excited i can actually help! select the cell you would like to format right click, then select the option "format cells..." make sure the number tab is selected, and scroll down to the category "custom" in the entry space labeled "Type:", type 10 zeros or however many you want finish by selecting ok "AccessNewbie" wrote: The results from one field in my query is in this format: 2316.52 I need that to look like this: 0000231652 Which is 10 characters long, zero filled, and without the decimal. Can anyone help? -- Thanks from a frustrated accountant |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Combo Box (1st) Populating Text Box (2nd) Field | AccessRookie | Using Forms | 1 | April 6th, 2005 11:37 PM |
GET.CELL | Biff | Worksheet Functions | 2 | November 24th, 2004 07:16 PM |
Setting A Number Equal to Another Number | slag018 | General Discussion | 1 | October 19th, 2004 04:16 AM |
Restart Autonumber | Traci | New Users | 22 | July 21st, 2004 01:10 AM |
Negative number formating | Lorenzo | Worksheet Functions | 1 | October 4th, 2003 09:22 PM |