Excel Help

  babybell 13:11 08 Jul 09
Locked

Is is possible to customise a cell so that if I type in a number, it adds an 'm' onto the end?

As part of a fitness programe I want to keep track of the distance I am rowing but with lots of other information on the form, I dont want to use up additional cells with simply 'm' in them to appear next to the distance. Is it possible to format a cell so that when i type in 2000, for example, Excel shows it as 2000m?

  OTT_Buzzard 13:25 08 Jul 09

Right click on the cell in question, select Format Cell then select Custom.

Enter #######"m" into the 'Type' box and click ok.

  babybell 13:33 08 Jul 09

Worked a treat, thanks very much!

  babybell 10:02 13 Jul 09

Using the code above, when I enter a number with a decimal point in it (52.5) for example, it is rounding the number up to 53. How Can I alter the forumala so that m is still shown but the number shows, say, two decimal places?

  VoG II 10:24 13 Jul 09

Try a Custom format

0.00"m"

This thread is now locked and can not be replied to.

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

How Nearly Normal created super-fun papercraft for Google

47 iPhone camera tips to help you take better photos