try this

Sub SaveFile()
Dim sf As String
ActiveCell.Select
Selection.NumberFormat = "0"
sf = ThisWorkbook.Path
ThisWorkbook.SaveAs Filename:=sf & "\" & "123" & ".csv"
End Sub



On Sep 29, 5:12*am, Srinivas
wrote:
Thanks for the reply, but our software takes only numerical when im trying to
upload its giving numerical error
--
srinivas



"muddan madhu" wrote:
try this

format cells | number tab | category :number | decimal places :0 | ok
|
File | save as | csv extension | ok | then rename the saved file
as .txt |
then open new excel | file | open | choose file type : all files |
choose file | open | delimited | next |
check comma | next | choose text option as display 14 digit | finish |

On Sep 29, 10:30 am, Srinivas
wrote:
Sir,

Actually I am uploading a barcode file which is in .csv format to our
software. *Our barcodes are 14 digits when im uploading it is taking like
8.9029E+12 instead of 8902900259286 what ever doing format once i close and
opens it is again going to 8.9029E+12 format. Please help me

Thanks & regards,
--
srinivas

"Joel" wrote:
Excel is converting the number to Scientific notation. *You want to go to
formating and change the number of decimal places to a larger number to
handle you large numbers.

"Srinivas" wrote:

Hi

When iam typing number (14 digits) in excel which is .csv format it is
giving error 8.9029E+12 like this i tried to format in general, number, text
but error remains same once i saved and reopen the file can any one help me
in this

Thanks
--
srinivas- Hide quoted text -

- Show quoted text -