Microsoft Excel - exlpro - Asked By usha anu on 02-Feb-12 07:16 AM
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
Danasegarane Arunachalam replied to usha 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 usha anu on 02-Feb-12 08:58 AM
[)ia6l0 iii replied to usha 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"
usha 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.
[)ia6l0 iii replied to usha anu on 03-Feb-12 03:21 AM
Can we talk with a specific example?
usha anu replied to [)ia6l0 iii on 03-Feb-12 03:55 AM
in column A value in time formate , i need the same value but in General .
[)ia6l0 iii replied to usha 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?