Microsoft Excel - exlpro - Asked By anu anu on 02-Feb-12 07:16 AM

 hi ,

 i have some data like in time format i want data in number formate, exmp

 i have data like 0:05 and i need like 0.05

 thanks

 usha
Danasegarane Arunachalam replied to anu anu on 02-Feb-12 08:56 AM
1.Right Click the cell, Choose format
2.From the popup replace the : with .


Danasegarane Arunachalam replied to anu anu on 02-Feb-12 08:58 AM
Screen Shot

[)ia6l0 iii replied to anu anu on 02-Feb-12 09:46 AM
My reply would have been same as above. But with a small difference. 

The format that I would rather choose would be "h.mm"
anu anu replied to [)ia6l0 iii on 03-Feb-12 02:10 AM
 
 hi thanks dear,

 i need in number formate but whenever i change data in number the value has been change but  i want , value will be same. like i want replace value 0:05 , to 0.05 privious value in time formate but i want 0.05 in number formate.

thanks 
usha

 
[)ia6l0 iii replied to anu anu on 03-Feb-12 03:21 AM
Can we talk with a specific example?
anu anu replied to [)ia6l0 iii on 03-Feb-12 03:55 AM


  hi exmp
 
 
A B
0.05 0.05
1.05 1.05
2.05 2.05
3.05 3.05
4.05 4.05
5.05 5.05
6.05 6.05
   


  in column A value in time formate , i need the same value but in General .

 
[)ia6l0 iii replied to anu anu on 03-Feb-12 10:31 AM
Sorry. I don't understand your example either. 

Both the Cells seem to have same values. Can you try to be more specific?