I want the vba code to format the cells of workbook like this:
if the number entered in cells is greater or equal to 1 to have 2 digits for integer and 1 for float( NumberFormat="00.0". Example 02.3)
And if number is lower than 1 Numberformat="0.0". Example 0.8)
Thank you in advance
It would probably be better to do this with conditional formatting. You would choose "Format only cells that contain" then use a Custom format for numbers >= 1. (Numbers <1 are using the default format so nothing special is needed for those.)
nnanos CF.jpg
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
I know how to do this way but it is imposible because i create new excel files using vba code and i want code to be put inside the code of creation!Originally Posted by 6StringJazzer
Last edited by nnannos; 05-19-2016 at 02:07 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks