How to change number value

timpepu

Registered User.
Local time
Today, 06:53
Joined
Nov 6, 2009
Messages
22
Hi !

I have imported textfile and the numbers are like 500000000 but it shuold be like 500,00 how can I correct it ?

Bs
Timo
 
If you have done, this in Ms.Excel, then Select the entire column in which you have this data, Click on Format/Cells a dialog box is displayed, Click on Number if Number tab is not displayed, select the required format and click ok. this should solve your problem.

If in Ms.Access, then format the text box in which this value will be displayed with format property in the textbox properties.
 
If you have done, this in Ms.Excel, then Select the entire column in which you have this data, Click on Format/Cells a dialog box is displayed, Click on Number if Number tab is not displayed, select the required format and click ok. this should solve your problem.

If in Ms.Access, then format the text box in which this value will be displayed with format property in the textbox properties.

The file is a ready ascii text file not imported from excel ?
 
The fact that it is stored in the field without the formatting is of no consequence, you simply need to incorporate the formatting when you display it.

David
 
how can a number like 500.00 be imported with more trailing zeroes to become another number

I would look carefully at your file layout - maybe some of the zeroes are something else - or maybe there is an implied decimal in there - you need to understand what is happening, before jumping to solutions
 

Users who are viewing this thread

Back
Top Bottom