By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 1,249 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

probleum in displaying the price in decimal format

100+
P: 198
hello expert
i made a programe in vb6.0 and i want to display the price in decimal format like e.g. 2323.90
i am sending my program line where i want to change the price format

ls1Level = ls1Level & Trim(rsMn.Fields("PRICE")) & Space(8 - Len(Trim(rsMn.Fields("PRICE"))))

and the value in ls1Level= " 1 TSNL 204"
here 204 is the price of any item "TSNL" having serial no 1
how can i insert the format function in the above line

thanks in advance
varinder
Jan 30 '08 #1
Share this Question
Share on Google+
1 Reply


P: 68
hello expert
i made a programe in vb6.0 and i want to display the price in decimal format like e.g. 2323.90
i am sending my program line where i want to change the price format

ls1Level = ls1Level & Trim(rsMn.Fields("PRICE")) & Space(8 - Len(Trim(rsMn.Fields("PRICE"))))

and the value in ls1Level= " 1 TSNL 204"
here 204 is the price of any item "TSNL" having serial no 1
how can i insert the format function in the above line

thanks in advance
varinder

Hi,
U can try by the following code:

Format("204", "00.00")

Get Better.

shuvo2k6
Jan 30 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.