formatting

[ads_1471]

I have converted time format from 08:30 to be 830,

However when trying to change the number format from custom to general it goes to 0.3542

How do I stop it going to 0.3542 and stay as 830 in general format

 

[RoryA]

You'd have to convert the actual cell value. 830 is not the same as 8:30 since Excel stores times as fractions of 1. Why do you need to do this?

 

[Joe4]

It is important to understand Excel stores dates and times.
Basically, it stores them as numbers, specifically, the number of days since 1/0/1900. And time is just the fraction of a day. The date/time is just a special formatting on this number.
So, 8:30 AM is really 8.5/24, which is equal to 0.3542 (which is why you are seeing that).

If you want to convert it to a number like "830", you can use the following formula (for a cell on cell A1):

=TEXT(A1,[h]mm")*1