Change formats - stupid question

[cruyff73]

Sorry for a basic question but I'm an idiot

Been sent a sheet with custom format saying 7.50 h. I want to get rid of the h and just leave the value. Tried changing format type but that doesn't work. How do I do it please?

 

[Joe4]

If you go to the cell, right-click "Format Cells", and go to the Number tab, what exactly does it show as the Custom format?

And if you go to the cell, and hit F2 to edit it, what does it show as the actual value entered into the cell?

 

[cruyff73]

If you go to the cell, right-click "Format Cells", and go to the Number tab, what exactly does it show as the Custom format?

And if you go to the cell, and hit F2 to edit it, what does it show as the actual value entered into the cell?

Hi,
It's Custom 0.00"h" and value is 7.50 h

 

[Joe4]

Hi,
It's Custom 0.00"h" and value is 7.50 h

If the Custom Format is 0.00"h", your actual entry should NOT have the "h" in it!
That defeats the purpose of having the Custom Format adding the "h", if the entry also has the "h" in it.
If the entry already has the "h" in it, then the Custom Format will not touch it anyway, as Custom Formats only work on numeric entries, and if the entry actually has a "h" physically in it, it is actually a Text entry, not a Numeric one.

The actual entry of your cell should just be: 7.5
Then the Custom Format would display it as "7.50h"

To physically remove the "h" for all your entries at once, simply select that column of that, and do a "Find/Replace", replacing "h" with nothing.
And if you do not want to see the "h" displayed, just change your Custom Format to a Numeric one.

 

[cruyff73]

If the Custom Format is 0.00"h", your actual entry should NOT have the "h" in it!
That defeats the purpose of having the Custom Format adding the "h", if the entry also has the "h" in it.
If the entry already has the "h" in it, then the Custom Format will not touch it anyway, as Custom Formats only work on numeric entries, and if the entry actually has a "h" physically in it, it is actually a Text entry, not a Numeric one.

The actual entry of your cell should just be: 7.5
Then the Custom Format would display it as "7.50h"

To physically remove the "h" for all your entries at once, simply select that column of that, and do a "Find/Replace", replacing "h" with nothing.
And if you do not want to see the "h" displayed, just change your Custom Format to a Numeric one.

Of course it is, said I was an idiot. Can't my brain in gear. Cheers Joe

 

[Joe4]

No worries!
Glad I was able to help!