how do i export numbers without the decimal points?

's Computer Specifications

hi
I need a export data into a .ndf file for SUN application without the
decimal in the number field. eg 15.56 must be 1556.
Please help.

thank you

's Computer Specifications

=[somefield]*10

--
Rick B

"Leon" <(E-Mail Removed)> wrote in message
news:47DBED08-ED7F-46A6-9515-(E-Mail Removed)...
> hi
> I need a export data into a .ndf file for SUN application without the
> decimal in the number field. eg 15.56 must be 1556.
> Please help.
>
> thank you
>

's Computer Specifications

Shouldn't that be =[somefield]*100?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Rick B" <Anonymous> wrote in message
news:%(E-Mail Removed)...
> =[somefield]*10
>
> --
> Rick B
>
>
>
> "Leon" <(E-Mail Removed)> wrote in message
> news:47DBED08-ED7F-46A6-9515-(E-Mail Removed)...
>> hi
>> I need a export data into a .ndf file for SUN application without the
>> decimal in the number field. eg 15.56 must be 1556.
>> Please help.
>>
>> thank you
>>
>
>

's Computer Specifications

Should be *100.

Jon

"Rick B" <Anonymous> wrote in message
news:%(E-Mail Removed)...
> =[somefield]*10
>
> --
> Rick B
>
>
>
> "Leon" <(E-Mail Removed)> wrote in message
> news:47DBED08-ED7F-46A6-9515-(E-Mail Removed)...
>> hi
>> I need a export data into a .ndf file for SUN application without the
>> decimal in the number field. eg 15.56 must be 1556.
>> Please help.
>>
>> thank you
>>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Open file and set numbers of decimal points	BlackSun	Microsoft Excel Programming	5	15th Mar 2011 06:01 PM
sorting numbers with decimal points	Trish	Microsoft Excel Worksheet Functions	1	2nd Jan 2008 05:09 PM
input masks to accept only numbers and decimal points	fcinelli@gmail.com	Microsoft Access	4	21st Feb 2007 07:50 PM
all the cells in excell put 2 decimal points in all numbers no ma.	=?Utf-8?B?Y2Fycm9sbDYxNg==?=	Microsoft Excel Misc	4	1st Dec 2005 04:01 AM
Sorting numbers with multiple decimal points?	Jonathan	Microsoft Excel Discussion	10	17th May 2005 10:36 PM