How to change number value

[timpepu]

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

 

[Repath]

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.

 

[timpepu]

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 ?

 

[DCrake]

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

 

[Repath]

The file is a ready ascii text file not imported from excel ?

then, import to excel, format and export to text format.

 

[gemma-the-husky]

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